|Oracle9i Database Reference
Release 2 (9.2)
Part Number A96536-01
Oracle Wait Events, 2 of 5
Information about wait events is displayed in three dynamic performance views:
V$SESSION_WAITdisplays the events for which sessions have just completed waiting or are currently waiting.
V$SYSTEM_EVENTdisplays the total number of times all the sessions have waited for the events in that view.
V$SESSION_EVENTis similar to
V$SYSTEM_EVENT, but displays all waits for each session.
Many of these wait events are tied to the internal implementation of Oracle and therefore are subject to change or deletion without notice. Application developers should be aware of this and write their code to tolerate missing or extra wait events.
This appendix describes the event name, wait time, and parameters for each event.
The following SQL statement displays all Oracle events: