所有进程空闲时,逻辑库竟然延时
select * from v$logstdby_process
2 ;
SID SERIAL# LOGSTDBY_ID SPID TYPE STATUS_CODE STATUS HIGH_SCN
---------- ---------- ----------- ------------ ------------------------------ ----------- -------------------------------------------------------------------------------- ----------
311 19461 -1 26262 COORDINATOR 16116 ORA-16116: no work available 2870648305
332 38062 0 30445 READER 16116 ORA-16116: no work available 2870648305
371 8621 1 30447 BUILDER 16116 ORA-16116: no work available 2870648305
360 63186 2 30449 PREPARER 16116 ORA-16116: no work available 2870648305
544 58447 3 30451 ANALYZER 16116 ORA-16116: no work available 2870648305
364 35105 4 30453 APPLIER 16116 ORA-16116: no work available 2870648304
484 4127 5 30455 APPLIER 16116 ORA-16116: no work available 2870648305
425 27019 6 30457 APPLIER 16116 ORA-16116: no work available 2870648304
434 8174 7 30459 APPLIER 16116 ORA-16116: no work available 2870648302
511 132 8 30461 APPLIER 16116 ORA-16116: no work available 2870648304
逻辑库的时间
select * from v$Logstdby_progress
apply_time 总是延迟4分钟左右。
最后一查。原来是主库的时间有问题。没有和时间服务器同步,慢了4分钟。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8135069/viewspace-686958/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8135069/viewspace-686958/