select
  inst_id,                                 -- INST_ID NUMBER
  sid,                                     -- SID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  logstdby_id,                             -- LOGSTDBY_ID NUMBER
  pid,                                     -- SPID VARCHAR2(12)
  type,                                    -- TYPE VARCHAR2(30)
  status_code,                             -- STATUS_CODE NUMBER
  status,                                  -- STATUS VARCHAR2(256)
  high_scn                                 -- HIGH_SCN NUMBER
from
  x$krvslv
where
  exists (
  select
    1
  from
    v$session s,
    x$knstacr x
  where
    s.sid=x.sid_knst and s.serial#=x.serial_knst)