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