DOUG presentation on dbms_xplan
Posted by Riyaj Shamsudeen on October 22, 2012
Please join us at the DOUG (DALLAS ORACLE USERS GROUP) Oracle Database Forum meeting on Thursday, October 25, 2012 from 5 pm – 7 pm.
Presented by Riyaj Shamsudeen, OraInternals, & Sahil Thapar:
“Out with the old way, Enter dbms_xplan: A Swiss army knife for performance engineers”
Rough outline:
(i) Ability to query access path from memory, AWR repository
(ii) Ability to use cardinality feedback method to understand access plan issues. Few tips from a real world experience will be provided too.
(iii) Ability to understand issues with database links etc.
(iv) Options such as ADVANCED, ALLSTATS etc
(v) Why should you choose dbmx_xplan over tkprof+sql_trace combination?
(vi) Disadvantages of dbms_xplan and a quick introduction to dbms_monitor.
Refreshments sponsored by me 
Update: Uploading the presentation pdf files. Enjoy
Srinivas Varala said
Riyaj,
You are doing great service to oracle community. I have learnt so much from your training and blog. please post your presentation on dbms_xplan in your blog. Unfortunately I am far away from Dallas.
Thanks
Srinivas
krish said
The paper listed autotrace shows the actual plan. That is incorrect. autotrace uses EXPLAIN PLAN and so cannot show the explain plan when things like bind peeking takes place.
Venky said
Great paper Riyaj. I am looking for something like this right now.