How to Develop Solutions When the Top “Event” is “DB CPU”

January 4, 2017 @ 1:00 pm – 2:00 pm
IOUG Webinars
How to Develop Solutions When the Top “Event” is “DB CPU” 
Wednesday, January 4, 2017 1:00 PM – 2:00 PM EST
Featured speaker: Craig A. Shallahamer
                               President & Founder, OraPub – Oracle ACE Director
Overall performance is less than ideal as far as the users are concerned. After months of meetings, management finally wants you to get involved. You run an AWR report for one of the most intense hours and notice the top “event” is “DB CPU,” followed by “cursor: pin S wait on X.” This is where the webinar begins!

Craig will demonstrate how to do an Oracle time based analysis, looking at the OS and also the “top” SQL. This journey also includes a trip into Oracle’s library cache, serialization control and some interesting ways to improve SQL statement performance.