-- quesced mode
-- put a database in a state that allows only DBA transactions
ALTER SYSTEM UNQUIESCE;
ALTER SYSTEM QUIESCE RESTRICTED;


-- v$blocking_quiesce
select bl.sid, user, osuser, type, program
from v$blocking_quiesce bl, v$session se
where bl.sid = se.sid;

-- when v$blocking_quiesce is not working (non standard consumer groups)
select username, count(1) from v$session
where sid IN (select SID_KGSKVFT from x$kgskvft)
group by username