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