OraPub | Oracle: How To Optimize Performance When The Top Event Is DB CPU

In this webinar Oracle Ace, Craig Shallahamer, will demonstrate how to do an Oracle time based analysis including integrating the OS situation into our analysis and finding the true “top” SQL.

This journey includes a trip into Oracle’s library cache, memory access control and some interesting ways to improve SQL statement performance.

Overall performance sucks 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!

🔵⚪️🔵⚪️🔵⚪️🔵

OraPub is a one-stop location for specialized training in machine learning and Oracle database performance tuning. Our company is designed to help Oracle professionals get the answers and skills they need through engaging training and useful resources.
 
We cross-train Oracle DBAs to develop and deploy machine learning for their existing monitoring and alerting systems. Our training and services provide an immediate return on investment.
 
Our online training is uniquely structured for the working professional. For example, all our LVCs are delivered in multiple two-hour sessions, with a day between each session, complete with homework. Craig Shallahamer encourages dialogue throughout every class to ensure students can immediately apply the course content.
 
With 30 years of experience specializing in Oracle performance and data analysis, Craig's passion and contagious energy for teaching Oracle managers, developers and DBAs makes the learning process valuable – and fun!

Craig Shallahamer is President and Founder of OraPub, with over 30 years of experience in consulting, training and tool development in analytics (machine learning) and Oracle database performance tuning for literally hundreds of companies around the world, including Oracle Corporation.
 
Craig holds a B.S. in Economics from California Polytechnic State University, San Luis Obispo and is an Oracle ACE Director.

For more information visit or to have full access to ALL our webinar content go to www.orapub.com