查看状态:
SELECT SESSION_ID, STATE FROM VLOGSTDBY_STATE;
SELECT SID, SERIAL#, SPID, TYPE FROM VLOGSTDBY_PROCESS;
等待阶段
SELECT STATUS FROM V$LOGSTDBY_PROCESS WHERE TYPE = ‘READER’;
监控sql apply过程
最新推荐文章于 2022-01-04 14:19:19 发布
查看状态:
SELECT SESSION_ID, STATE FROM VLOGSTDBY_STATE;
SELECT SID, SERIAL#, SPID, TYPE FROM VLOGSTDBY_PROCESS;
等待阶段
SELECT STATUS FROM V$LOGSTDBY_PROCESS WHERE TYPE = ‘READER’;