CHAPTER 4OWI Monitoring and Collection Methods

Prescribing the right solution for performance problems the first time is the ultimate goal of every tuning practitioner. This may be relatively easy if the problem is a current one, but it could be daunting if the performance problem happened in the past, and you are called upon to determine the root cause and provide a solution to prevent it from happening again. This task can be unbearable when pressure is added because the severity and visibility levels of the performance problem are high and the whole organization is watching and expecting only positive results, especially if your boss is breathing down your neck.

Performance diagnosis is a major part of tuning, and a good collection of historical ...

Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.