select
  sid,                                     -- SID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  logstdby_id,                             -- LOGSTDBY_ID NUMBER
  spid,                                    -- SPID VARCHAR2(12)
  type,                                    -- TYPE VARCHAR2(30)
  status_code,                             -- STATUS_CODE NUMBER
  status,                                  -- STATUS VARCHAR2(256)
  high_scn                                 -- HIGH_SCN NUMBER
from
  gv$logstdby_process
where
  inst_id = USERENV('Instance')