GV$LOGSTDBY_STATE select inst_id, -- INST_ID NUMBER primary_dbid, -- PRIMARY_DBID NUMBER session_id, -- SESSION_ID NUMBER realtime_apply, -- REALTIME_APPLY VARCHAR2(64) state -- STATE VARCHAR2(64) from x$krvslvst