As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool
As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool
There are few ways to see the execution plan of a SQL statement. One of these ways is the autotrace option in sqlplus. It is a very easy-to-use feature and
My previous post that showed a real life troubleshooting was a hit. I guess people like to hear these kind of things, so I decided to write another post, this
People ask me quite a lot about how I analyze performance issues. While I have some guidelines, there is no complete answer to this question. The actions I take depend
When Oracle releases a new version or even a patchset, sometimes they change the default value of initialization parameters or add new features and introducing new parameters with them. These
If you have read my previous post about this (if not, you can find it here), you know that I found a cardinality issue with 12c top-N queries (or row
While writing the last post about paging queries (can be found here) I checked the 12c new top-n feature.The idea behind this feature is to tell Oracle, in native SQL
In the past few months I had several occasions to use the “rownum” pseudo-column to page a query result set. As we know, a query returns a result set, which
Over the years I ran into many Oracle bug related to the optimizer (the last one was yesterday with join push predicates). Many times this is related to Optimizer new