重庆思庄Oracle、Redhat认证学习论坛

标题: alert日志中出现Warning: VKTM detected a time drift [打印本页]

作者: 刘泽宇    时间: 2020-10-24 18:57
标题: alert日志中出现Warning: VKTM detected a time drift
在查看alert日志时,发现其中持续出现一个warning告警Warning: VKTM detected a time drift
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.


经过查询官方文档,证实是由于oracle11.2.0.4上的bug引起的(官方文档ID 1678120.1
This problem is due to the Bug 11837095 - "TIME DRIFT DETECTED" APPEARS INTERMITTENTLY IN ALERT LOG"
处理方法为:
1.在实例上设置一个事件,使这个告警信息不再出现:
SQL> alter system set event="10795 trace name context forever, level 2" scope=spfile;
2.重启实例使之更改生效


这个bug在oracle12c版本已经修复,如果这个告警没有出现实质性的影响可以忽略不做处理





欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2