v$system_event

2023-08-18 09:26:34  Updated

Overview

v$system_event displays tenant-level wait events.

gv$system_event

Field description

Field name Type Nullable Description
CON_ID BIGINT(20) No The ID of the tenant.
EVENT_ID BIGINT(20) No The ID of the wait event.
EVENT varchar(64) No The description of the wait event.
WAIT_CLASS_ID BIGINT(20) No The ID of the class to which the wait event belongs.
WAIT_CLASS BIGINT(20) No The subscript of the class to which the wait event belongs.
WAIT_CLASS varchar(64) No The name of the class to which the wait event belongs.
TOTAL_WAITS BIGINT(20) No The total number of waits for the event.
TOTAL_TIMEOUTS BIGINT(20) No The total number of timeouts for the event.
TOTAL_WAITED DOUBLE No The total wait time for the event, in hundredths of a second.
AVERAGE_WAIT DOUBLE No The average wait time for the event, in hundredths of a second.
TOTAL_WAITED_MICRO BIGINT(20) No The total wait time for the event in microseconds.

Contact Us