GV$WAITCLASSMETRIC
SELECT inst_id, -- INST_ID NUMBER begtime, -- BEGIN_TIME DATE endtime, -- END_TIME DATE intsize_csec, -- INTSIZE_CSEC NUMBER wait#, -- WAIT_CLASS# NUMBER wait_id, -- WAIT_CLASS_ID NUMBER average_waiter_count, -- AVERAGE_WAITER_COUNT NUMBER dbtime_in_wait, -- DBTIME_IN_WAIT NUMBER time_waited, -- TIME_WAITED NUMBER wait_count -- WAIT_COUNT NUMBER FROM x$kewmevmv WHERE flag1 = 1 AND GROUPID = 1

home |  up  |  mailbox