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