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')