V_$SYSTEM_EVENT

컬럼명	설명	예
EVENT	Name of the wait event
TOTAL_WAITS	Total number of waits for the event
TOTAL_TIMEOUTS	Total number of timeouts for the event
TIME_WAITED	Total amount of time waited for the event (in hundredths of a second)
AVERAGE_WAIT	Average amount of time waited for the event (in hundredths of a second)
TIME_WAITED_MICRO	Total amount of time waited for the event (in microseconds)
EVENT_ID	Identifier of the wait event
WAIT_CLASS_ID
WAIT_CLASS#
WAIT_CLASS

   

참고질의 :

sys>get systemEvent

select * from (select event,total_waits,time_waited,average_wait,

wait_class from

v$system_event order by average_wait desc)

where rownum<10