Intermediate SQL Color Coded SQL, UNIX and Database Essays

23Sep/110

How to find if your SQL is using SPM baseline

I’ve always wondered how many of my SQLs are NOT using baselines.

Of course, when you run DBMS_XPLAN.DISPLAY_CURSOR for the statement, it can put a nicely formatted note for you, something like:

Note
-----
- SQL plan baseline "SQL_PLAN_01yu884fpund494ecae5c" used FOR this statement

But can you find it globally for ALL SQLs in the shared pool ?

Want to copy data faster than SCP ? Check out my new blog entry: http://t.co/nTpI4jfx 07:05:17 PM May 16, 2012 from web Reply Retweet Favorite
Validate constraint in PARALLEL: alter table PARALLEL + alter table ENABLE VALIDATE constraint 01:35:54 AM June 26, 2011 from web Reply Retweet Favorite
You can active duplicate from physical STANDBY database, if you set state=APPLY-OFF on standby 12:57:34 AM May 08, 2011 from web Reply Retweet Favorite
Golden rule of PAGINATION INDEXING - Either "fix" leftmost columns (c=v) OR include them in ORDER BY 08:39:27 PM April 21, 2011 from web Reply Retweet Favorite
Golden rule of PARTITIONING - If you can't make 99% of your SQLs hit a single partition -> don't do it ! 08:37:15 PM April 21, 2011 from web Reply Retweet Favorite