Posted by sqlmdx on December 19, 2015
New syntax for so called “Top N” queries was introduced in Oracle 12c.
It can be used to return either fixed number of rows or specified percent of rows in a table.
Obviously latter requires to know the total number of rows to return the result so let’s check what is happening under the hood in this case.
Read the rest of this entry »
Posted in Oracle | Tagged: 12c, performance tuning | Leave a Comment »
Posted by sqlmdx on December 13, 2015
I’ve described how to measure context switches some time ago in this post.
Given that with_clause allows to declare PL/SQL functions in 12c it’s interesting to analyze overhead for context switches in this case.
Read the rest of this entry »
Posted in Oracle | Tagged: 12c, internals | Leave a Comment »
