V$EVENTMETRIC

V$EVENTMETRIC displays values of wait event metrics for the most recent 60-second interval.

Column Datatype Description
BEGIN_TIME DATE Begin time of the interval
END_TIME DATE End time of the interval
INTSIZE_CSEC NUMBER Interval size (in hundredths of a second)
EVENT# NUMBER Number of the event
EVENT_ID NUMBER Identifier of the event
NUM_SESS_WAITING NUMBER Number of sessions waiting at the end of the interval
TIME_WAITED NUMBER Time waited (in hundredths of a second)
WAIT_COUNT NUMBER Number of times waited
TIME_WAITED_FG NUMBER Time waited (in hundredths of a second), from foreground sessions
WAIT_COUNT_FG NUMBER Number of times waited, from foreground sessions