OraPub | Detailing Oracle CPU Consumption: The Missing Link

Detailing Oracle CPU Consumption: The Missing Link helps Oracle Database Administrators answer this question, "What's Oracle doing with all that CPU?"
For details go to www.orapub.com/...
Here's the problem: While Oracle has the world's most advanced database wait time instrumentation, Oracle does NOT instrument CPU consumption. This presents the Oracle DBA with a tuning handicap because CPU consumption can be a significant component of database time. The unintentional result can be solutions with a wait time bias and solution guessing.
In this session you will learn how to determine where Oracle is consuming CPU down to the Oracle kernel code function level and how this relates to the broader performance situation. Now you will be able to more effectively develop solutions to reduce both CPU consumption and wait time.
Important: The solution created to solve the CPU detail limitation is Linux based. While I'm confident there are very similar solutions in other operating systems, I do not explore this.
What You Will Learn
How to answer the question, "Is that process doing anything or stuck?"
How to answer the question, "So what is Oracle doing with all that CPU?"
How to overcome the problem of understanding limitation when there is little wait time but lots of CPU time.
Finding the Oracle kernel function when there could be a possible bug.
Helping you understand what Oracle is doing, "under the hood."
Modules
The problem and what to do about it
My journey to find a solution
Creating the solution based on the Linux "perf" tools
Examples of how to use the tool in production situations
For information on how you can watch the whole seminar or for more great eduction from OraPub, go to www.orapub.com
🔵⚪️🔵⚪️🔵⚪️🔵
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.
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's passion and contagious energy for teaching Oracle managers, developers and DBAs makes the learning process valuable - and fun!
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