Updated on 2024-05-07 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 both PG_CATALOG and SYS schema.

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. Its value is NULL.

total_timeouts_fg

numeric

Not supported. Its value is NULL.

time_waited_fg

numeric

Not supported. Its value is NULL.

average_wait_fg

numeric

Not supported. Its value is NULL.

time_waited_micro_fg

numeric

Not supported. Its value is NULL.

event_id

numeric

Not supported. Its value is NULL.

wait_class_id

numeric

Not supported. Its value is NULL.

wait_class#

numeric

Not supported. Its value is NULL.

wait_class

character varying(64)

Class name of a wait event

con_id

numeric

Not supported. Its value is 0.