Pages

Saturday, June 7, 2014

"Warning: VKTM detected a time drift" in 11gR2

ALERT LOG
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.

Cause
This problem is due to the Bug 11837095 - "TIME DRIFT DETECTED" APPEARS INTERMITTENTLY IN ALERT LOG"

Solution
Time drift" error is a " message which can be ignored, to remove the "Warning: VKTM detected set event 10795 or Apply patch 11837095

SQL> alter system set event="10795 trace name context forever, level 2" scope=spfile;

Then bounce the DB instances to implement the event/change.

2 comments:

  1. Same error occur in 12c (12.1.0.2) as well do we any other bug ?

    ReplyDelete
  2. Can I say what a relief to discover one who actually knows what theyre preaching about on-line. You certainly understand how to bring a challenge to light making it important. More and more people really need to check out this and understand why side of your story. I cant believe youre less well-known simply because you undoubtedly develop the gift. buy wall murals

    ReplyDelete