RMOUG 2012 Presentation Slides!
Graham Wood was kind enough to send me a quick email and let me know that my presentation slides weren’t downloading correctly from RMOUG’s website, so I’ve put them here for anyone that may like to have them.
I’m still recovering from the post RMOUG Training Day festivities, aka Foak Table, which was held up in Breckenridge again this year. I will make sure to blog about Training Days and the post event at a later date, but until then, here is a link to my slides. Please email me with any questions or comments you may have- always glad to chat!
EM12C
Sherlock Holmes for DBA’s
~Kellyn
Nice presentations Kellyn. A couple of comments:
1/ DBMS_MONITOR is another (preferred) way to turn on 10046 tracing
2/ The ASH Analytics Loadmap might have shown better broken down by SQL_ID first and Wait Class second. This way the total activity for a SQL_ID appears in single rectangle and can be easily compared to other SQL_IDs (by rectangle size), and also the Wait Class coloring would reflect the “branded” coloring of the Performance page to easily inspect the ratio of CPU to IO to Waits visually (by size of colored areas, lots of green = lots of CPU.)
3/ EXPLAIN PLAN is an outdated and often inaccurate means of determining query plan, using DBMS_XPLAN is advised.
4/ Users of prior EM releases will hopefully appreciate the new menus over the tabs-and-hyperlink-farms navigation models.
Kellyn,
It is surprising that you present DBMS_SQLDIAG, but do not mention DBMS_MONITOR for enabling SQL_TRACE.
DBMS_MONITOR has been the preferred way to enable SQL_TRACE since Oracle 10g.
Also, if you are doing time based tuning, as you should be SORT=prsela,exeela,fchela will give you output from tkprof ordered by total elapsed time.
A couple people noticed that I forgot to go into DBMS_MONITOR. I will add it to the presentation for next time! Thank you for bringing this to my attention, gentlemen.. 🙂
JB- I’m actually working on a separate ASH Analytics presentation for MOW2012. This should come across more complete and clearer than the quick run through I did as part of my EM12c presentation. I’m looking forward to digging into this further and having it more indepth/more clear.
Thank you!