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)