Issue:-

alert found into the alert logfile.

Warning: VKTM detected a forward time drift.

Time drifts can result in unexpected behavior such as time-outs.

Please see the VKTM trace file for more details:

/…………………………………/trace/<INSTNAME_vktm_100191.trc

Trace file  information:-

*** 2020-06-09 01:50:35.058

kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (8914177)usec at (606567530696) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:lowres): Time stalled at 1591668005

*** 2020-06-09 03:00:06.722
kstmchkdrift (kstmhighrestimecntkeeper:lowres): Stall, backward drift ended at 1591668006 drift: 1
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (20827068)usec at (628764932274) whereas (1000000) is allowed

*** 2020-06-09 08:06:50.417
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (3425343)usec at (629135770137) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1752783)usec at (629152967094) whereas (1000000) is allowed

*** 2020-06-09 08:07:15.555
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1927310)usec at (629160907824) whereas (1000000) is allowed

*** 2020-06-09 08:07:22.001
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1045550)usec at (629167353678) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (9883474)usec at (650980849367) whereas (1000000) is allowed

*** 2020-06-09 14:16:55.523
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (5572366)usec at (651334658429) whereas (1000000) is allowed

*** 2020-06-09 14:17:07.755
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1767549)usec at (651346889548) whereas (1000000) is allowed

*** 2020-06-09 14:17:13.597
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1724214)usec at (651352731509) whereas (1000000) is allowed

*** 2020-06-09 14:17:15.627
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1436000)usec at (651354762365) whereas (1000000) is allowed

*** 2020-06-09 14:17:17.022
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1197067)usec at (651356157174) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (8572706)usec at (672871286376) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1576580)usec at (673265980382) whereas (1000000) is allowed

*** 2020-06-09 20:22:35.077
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1535101)usec at (673271145160) whereas (1000000) is allowed

*** 2020-06-09 20:22:39.523
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1282610)usec at (673275591047) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (24717852)usec at (694950560985) whereas (1000000) is allowed

*** 2020-06-10 02:23:59.562
kstmchkdrift (kstmhighrestimecntkeeper:lowres): Time stalled at 1591752239

*** 2020-06-10 02:24:00.562
kstmchkdrift (kstmhighrestimecntkeeper:lowres): Stall, backward drift ended at 1591752240 drift: 1

*** 2020-06-10 02:29:07.886
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1625056)usec at (695259885680) whereas (1000000) is allowed

*** 2020-06-10 02:29:18.496
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1999112)usec at (695270496269) whereas (1000000) is allowed

*** 2020-06-10 02:29:23.351
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1522429)usec at (695275351121) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (21132645)usec at (716880786496) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1502494)usec at (717635721550) whereas (1000000) is allowed

kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1390547)usec at (1469985085944) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (37827340)usec at (1491730580699) whereas (1000000) is allowed

*** 2020-06-19 07:50:08.768
kstmchkdrift (kstmhighrestimecntkeeper:lowres): Time stalled at 1592549408

*** 2020-06-19 07:50:09.769
kstmchkdrift (kstmhighrestimecntkeeper:lowres): Stall, backward drift ended at 1592549409 drift: 1
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (2646945)usec at (1492176038753) whereas (1000000) is allowed

*** 2020-06-19 07:57:42.776
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1810836)usec at (1492185590299) whereas (1000000) is allowed

*** 2020-06-19 07:57:48.930
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1991129)usec at (1492191744680) whereas (1000000) is allowed

*** 2020-06-19 07:57:50.775
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1122195)usec at (1492193590067) whereas (1000000) is allowed

Action plan:- 

Time drift error is a message which can be ignored, and to remove it you can set:
SQL> alter system set event=”10795 trace name context forever, level 2″ scope=spfile;
Then bounce the DB instances to implement the event/change.
Recent Posts

Start typing and press Enter to search