监控sql apply过程
查看状态:
SELECT SESSION_ID, STATE FROM VLOGSTDBY_STATE;
SELECT SID, SERIAL#, SPID, TYPE FROM VLOGSTDBY_PROCESS;
等待阶段
SELECT STATUS FROM V$LOGSTDBY_PROCESS WHERE TYPE = ‘READER’;
查看状态:
SELECT SESSION_ID, STATE FROM VLOGSTDBY_STATE;
SELECT SID, SERIAL#, SPID, TYPE FROM VLOGSTDBY_PROCESS;
等待阶段
SELECT STATUS FROM V$LOGSTDBY_PROCESS WHERE TYPE = ‘READER’;