DBA_HIST_SYSTEM_EVENT displays historical information on total waits for an event. This view contains snapshots of V$SYSTEM_EVENT.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
Unique snapshot ID | |
DBID |
NUMBER |
Database ID for the snapshot | |
INSTANCE_NUMBER |
NUMBER |
Instance number for the snapshot | |
EVENT_ID |
NUMBER |
Identifier of the wait event | |
EVENT_NAME |
VARCHAR2(64) |
Name of the wait event | |
WAIT_CLASS_ID |
NUMBER |
Identifier of the Class of the Wait Event | |
WAIT_CLASS |
VARCHAR2(64) |
Name of the Class of the Wait Event | |
TOTAL_WAITS |
NUMBER |
Total number of waits for the event | |
TOTAL_TIMEOUTS |
NUMBER |
Total number of timeouts for the event | |
TIME_WAITED_MICRO |
NUMBER |
Total amount of time waited for the event (in microseconds) |