Category Archives: Uncategorized

Top Misconceptions about DBaaS Snapclone

TweetThe last couple weeks I’ve been lucky enough to get time with a new ZFSSA Simulator, (it will be out soon for everyone, so you’ll have to just play with the current one available, patience grasshopper! :)) and spent checking out the newest features available with Database as a Service, (DBaaS) Snapclone via Enteprise Manager […]

Tags:  

Del.icio.us

Facebook
TweetThis
Digg
StumbleUpon


Copyright © DBA Kevlar [Top Misconceptions about DBaaS Snapclone], All Right Reserved. 2014.

NL History

Even the simplest things change – here’s a brief history of nested loop joins, starting from 8i, based on the following query (with some hints): There’s an index to support the join from t2 to t1, and I’ve forced an (unsuitable) index scan for the predicate on t2. Basic plan for 8i (8.1.7.4) As reported […]

Data toons: Cirque du DBA

It’s not uncommon for database administrators (DBAs) to feel like ring masters at the circus. But what happens when you free up in-house DBAs by outsourcing database management? This work is licensed under a Creative Commons Attribution-NoDerivs 3.0 Unported License. Based on a work at pythian.com/blog.

RHEL7 and Oracle Linux 7 beta

Nearly two weeks ago, Oracle announced the Oracle Linux 7 Beta 1. Being the Linux fanboy I am, I downloaded it straight away from here. Oracle Linux is a clone of the Red Hat Enterprise Linux (RHEL) distribution. The RHEL7 beta, and therefore OL7 beta, distro is based on a cut of Fedora 19, although depending […]


RHEL7 and Oracle Linux 7 beta was first posted on April 23, 2014 at 10:15 am.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Presenting at ODTUG Kscope14 Conference in Seattle June 22-26 2014

  Just a short note to say I’ll be presenting at the Oracle Development Tools User Group (ODTUG) Kaleidoscope 14 Conference this year in beautiful Seattle, Washington on June 22-26 2014. I had a fantastic time when I attended this conference a few years ago when it was held in Monterey so I’m really looking forward to […]

Some new Oracle Database 12c Articles

I’ve recently put some new Oracle 12c articles on the website. Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1) Capture Privilege Usage (DBMS_PRIVILEGE_CAPTURE) in Oracle Database 12c Release 1 (12.1) The privilege usage stuff is really cool. Normally, trying to figure out what you […]


Some new Oracle Database 12c Articles was first posted on April 22, 2014 at 7:18 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Indexing Foreign Key Constraints With Invisible Indexes (Invisible People)

In my previous post I discussed when deleting rows from parent tables, how Bitmap Indexes based on the FK constraint can prevent the expensive Full Tables Scans (FTS) on the child tables but not the associated exclusive table locks. Last year, I discussed how it was possible in Oracle Database 12c to have multiple indexes on the same column list. […]

ASH Analytics- Tracking Down an Issue, Part I

TweetThis is the first of many posts I’ll do where we take a particular issue and trouble-shoot.  I’ll go through multiple scenarios to show the common steps to take via the Enterprise Manager 12c from discovery to identification to research to explanation. This blog will use the following features: ASH Analytics SQL Details ASH Report […]

Tags:  

Del.icio.us

Facebook
TweetThis
Digg
StumbleUpon


Copyright © DBA Kevlar [ASH Analytics- Tracking Down an Issue, Part I], All Right Reserved. 2014.

Divergent

I’ve just got back from watching Divergent. It is a really good film! Don’t believe any bullshit comparisons to that crappy Hunger Games. It is so much better than that rubbish! It’s probably a good idea not to read any summaries of the plot either, since it sounds kind-of stupid on paper. In the film it […]


Divergent was first posted on April 22, 2014 at 12:16 am.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Performance Testing with Agile Data

Performance testing requires full, fresh data Many organizations don’t even attempt to test performance until very late in their development cycle because it is only in the UAT (or equivalent) environment that they have a full copy of their production data set.  Errors and inefficiencies found at this stage are expensive to fix and are […]