GV$BLOCKING_QUIESCE

select
inst_id,                 -- INST_ID NUMBER
sid_kgskvft              -- SID NUMBER
from
x$kgskvft 
where
active_kgskvft = 1 and mapped_cg_name_kgskvft <> 'SYS_GROUP'
home |  up  |  mailbox