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

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.