In a Nutshell
We discussed some wait events that are commonly seen in many databases, including the Real Application Clusters environment.
The wait parameters P1, P2, and P3 in the V$SESSION_WAIT view, or the V$SESSION view in Oracle Database 10g Release 1, provide more information to find the cause of the wait event. For some events, the columns P1RAW, P2RAW, and P3RAW of these views contain the needed information. The wait time, or timeout value, varies for various wait events. The event waits until the required action is completed or the required resource becomes available. The views V$SYSSTAT and V$SESSTAT are not part of the OWI. However, those provide vital information about CPU usage and other statistics.
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.
