I broke my routine and skipped breakfast this morning, but I made it here in time for Tanel's presentation!
Topics
Systematic Troubleshooting Approach
Metrics, what to use when?
Oracle 12c topics
OS touch-point and lower level stuff
Doing a really deep dive into today's presentation isn't fair to Tanel, or the other attendees that spent their cold hard cash to be here, so I'm only going to highlight a few items that might help you out. Before you leave! Tanel did post his Training Day from 2010 which had a lot of what he based today's presentation off of, so if you need to learn something from him here is an excellent opportunity.
Review the ASH table. There are some "hidden" gems in it!
What does IS_SQLID_CURRENT in ASH do or mean? Tanel doesn't know, he hasn't really used it. Sounds to me like a good thing to learn! He suggests that we read te documentation. :}
Totally off subject, but it makes me feel good that Tanel thinks he would fail some Oracle exams!
What are the different types of profiling, and what do you use?
Some tables mentioned today:
V$OSSTAT
V$SYS_TIME_MODEL
V$SESSTAT
V$SYSSTAT
V$TOPLEVELCALL
V$ENQUEUE_STATISTICS
DBA_HIST_SYSMETRIC
V$EVENT_HISTOGRAM
V$LATCH
V$LATCH_CHILDREN
Tools mentioned today:
Snapper script (located here)
Ashtop.sql (located here)
Swingbench
How does a phone bill relate to Oracle performance tuning? You'd be surprised! Great example!
Great use of EM to dive into a performance problem!
Tanel was channeling Cary Millsap a bit and it was awesome!
He taught us something about ASH Analytics in 12c, which looks really cool and useful too!
If you didn't attend Hotsos Symposium this year, I would strongly recommend it, and even MORE strongly recommend signing up for the Training Day next year!
No comments:
Post a Comment