GV$MUTEX_SLEEP
select INST_ID, -- INST_ID NUMBER MUTEX_TYPE, -- MUTEX_TYPE VARCHAR2(32) LOCATION, -- LOCATION VARCHAR2(40) SLEEPS, -- SLEEPS NUMBER WAIT_TIME -- WAIT_TIME NUMBER from x$MUTEX_SLEEP

home |  up  |  mailbox