Hi, This article will include a couple of great tips…one using a hint I work with in my SQL Tuning class and the other solving a performance issue with partitioning using PL/SQL Dynamic Execute Immedi...
Hi, Maybe you have wanted to use longer object names to be more descriptive. The Oracle RDBMS now supports up to 128 positions for both object and column names! The current naming length convention is...
I was able to attend the Oracle Open World 2016 event this past fall. Last April, I posted a nice series on In-memory, material I had gathered from Oracle PM Andy Revenes (heck of a nice guy). Here a...
A question came to me from a DBA friend asking about SQL differences between releases of the database. IE: behavioral differences in SQL processing. The question posed by this person was that they fe...
I have used the Toad explain plan advanced options to show SQL bind variable content for a while. I want to show you how to get this advanced information when doing SQL tuning with Toad. When tuning S...
If you have been in my tuning class or read my tuning blogs, I carry on at length about the importance of reviewing the explain plan with which the SQL executed, not an explain plan because you needed...
We continue this series of blogs on New Features for Developers with some updated conditional compilation features. Oracle10 introduced conditional compilation, or the ability to compile PL/SQL lines...
Hi, We continue this series of blogs on New Features for Developers with some updated conditional compilation features. This feature allows for you to get rid of the upper and lower functions when com...
Hi, We continue this series of blogs on New Features for Developers with some updated syntax to external tables. External tables are great and they have been around for a while. They are basically a ...
Hi, I’ll start this series of blogs on New Features for Developers. The first is quick but good! A while back, December of 2014 to be exact, I blogged about APPROX_COUNT and how much faster it was. T...
This trace has been around for quite a while. I’m not sure when it first showed up but easily back to Oracle8i. This is the Cost-based Optimizer trace. This trace really tells you ‘why did the CBO pr...
Ever wonder how to tell what columns would be good for indexes? Once the index is created, ever wonder why you never see it in SQL explain plans you would expect to see it in??? There are 2 useful st...
