Available Views for Oracle Wait Events

There are three dynamic performance views by which we can get information about the oracle wait events. Each of the wait events belong to a wait class.

The three dynamic performance views are,
1)V$SESSION_WAIT: This dynamic performance view displays the events for which sessions have just completed waiting or are currently waiting.

2)V$SYSTEM_EVENT: This view displays the total number of times all the sessions have waited for the events.

3)V$SESSION_EVENT: This view displays all waits for each session.

The list of all oracle wait events and their associated wait class can be found by querying,

SQL> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;