GV$LOGSTDBY
select inst_id, -- INST_ID NUMBER 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 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)

home |  up  |  mailbox