标题: 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.重启实例使之更改生效