Tagged articles
2 articles
Page 1 of 1
ITPUB
ITPUB
Sep 1, 2016 · Databases

Why Oracle VKTM Time Drift Happens and How to Resolve It

The article explains Oracle 11g's VKTM background process, how time drift warnings appear in the alert log, analyzes trace files to pinpoint the drift, discusses underlying causes such as OS load, and provides the patch and event‑setting steps needed to fix the bug.

Alert LogOracleTime Drift
0 likes · 8 min read
Why Oracle VKTM Time Drift Happens and How to Resolve It
ITPUB
ITPUB
May 23, 2016 · Databases

Why Do Oracle DBMS_JOBS Stop at the Year 4000? Root Cause and Fix

This article explains why an Oracle DBMS_JOB can become broken and show a next execution date of 4000‑01‑01, details the job parameters, the automatic retry logic, how to diagnose the underlying PL/SQL errors via alert logs, and provides concrete steps to restart and resolve the issue.

Alert LogDBMS_JOBJob Scheduling
0 likes · 6 min read
Why Do Oracle DBMS_JOBS Stop at the Year 4000? Root Cause and Fix