Lately I’m in the process of upgrading a few clients to 18c and 19c, so I expected to hit a few issues. In this post I’ll discuss a specific issue
Lately I’m in the process of upgrading a few clients to 18c and 19c, so I expected to hit a few issues. In this post I’ll discuss a specific issue
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
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
Oracle Virtual Technology Summit (VTS) is an online conference, organized by the OTN people, and presented by many Oracle employees and Oracle community experts. I’m proud to say that I
In Oracle 12c, when running DBMS_STATS to gather statistics on a partitioned table,we can (finally) gather statistics on all (or at least some) partitions at the same time.
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