V$EVENTMETRIC

Oracle 11gR1

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
WAIT_COUNT	NUMBER	Number of times waited

Note:

1. In some ways, this view is similar to the v$session_wait view, in that it maintains recent wait information. However, it is different in that this view stores system-wide information and instead of only storing current waits, it stores approximately one minute’s worth of history. The difference between current information and one minute of history seems small, but it becomes much easier to monitor ongoing sessions. The DBA could, for instance, have a procedure that captures v$eventmetric data every minute. Due to the history collected with v$eventmetric, significantly more data would be captured than if only v$session_wait data was captured at the same interval.

Oracle dynamic performance views