GV$MVREFRESH

select
inst_id,                 -- INST_ID NUMBER
sid_knst,                -- SID NUMBER
serial_knst,             -- SERIAL# NUMBER
currmvowner_knstmvr,     -- CURRMVOWNER VARCHAR2(31)
currmvname_knstmvr       -- CURRMVNAME VARCHAR2(31)
from
x$knstmvr x 
where
type_knst=6 and exists (
select
1 
from
v$session s 
where
s.sid=x.sid_knst and s.serial#=x.serial_knst)
home |  up  |  mailbox