CHAPTER 2Oracle Wait Interface Components
Oracle has always been self-monitoring, but it hasn’t always been self-tuning. This means there is a wealth of data in each Oracle instance that can help answer a lot of performance questions. You just need to know where to find the data. There is instance-level and session-level performance data, as well as current and historical activities in various views.
This chapter provides a roadmap into the Oracle Wait Interface. You will be introduced to all the wait event views; their applications, and the extended SQL trace facility (trace event 10046 with appropriate debug level) to capture wait events in a trace file. At the completion of this chapter you will know where, when, and how to find wait event ...
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.
