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 10 g 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.




Oracle Wait Interface
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
Year: 2004
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net