Updated on 2024-06-03 GMT+08:00

V$SYSTEM_EVENT

V$SYSTEM_EVENT displays information about all the wait events (summary of each wait event since the instance is started). By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

Table 1 V$SYSTEM_EVENT columns

Name

Type

Description

event

character varying(64)

Wait event name

total_waits

numeric

Total number of wait events

total_timeouts

numeric

Total number of timeout events

time_waited

numeric

Total time (in centiseconds) of wait events

average_wait

numeric

Average time (in centiseconds) of wait events

time_waited_micro

numeric

Total time (in microseconds) of wait events

total_waits_fg

numeric

Not supported. Set it to NULL.

total_timeouts_fg

numeric

Not supported. Set it to NULL.

time_waited_fg

numeric

Not supported. Set it to NULL.

average_wait_fg

numeric

Not supported. Set it to NULL.

time_waited_micro_fg

numeric

Not supported. Set it to NULL.

event_id

numeric

Not supported. Set it to NULL.

wait_class_id

numeric

Not supported. Set it to NULL.

wait_class#

numeric

Not supported. Set it to NULL.

wait_class

character varying(64)

Class name of a wait event

con_id

numeric

Not supported. Set it to 0.