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)