Search This Blog

Sunday 7 August 2022

ASM instance warning message in alert log file

“Warning: VKTM detected a time drift”


  Solution

Usually VKTM and VKRM issues come together, at least when you are using the resource manager. 

The VTKM is the Virtual Keeper of Time Process. The VKTM acts as a time publisher for an Oracle instance.  VKTM publishes two sets of time: a wall clock time using a seconds interval and a higher resolution time (which is not wall clock time) for interval measurements.  

The VKTM process is a process that is available in ASM instances and RDBMS instances. So if you see issues with VKTM process, it usually pops up on both. VKTM usage is affected mainly by two hidden parameters _timer_precision and _disable_highres_ticks. So, tuning these parameters can bring down VKTM CPU consumption.

The VKRM process is the Virtual Scheduler for Resource Manager Process, and it serves as centralized scheduler for Resource Manager activity. As there is no resource manager on a ASM instance, you will see this process only on RDBMS instances.


For version 11.2.0.1, Apply patch for Bug 9843304.  This Bug is already fixed in 11.2.0.2

For 11.2.0.2 and 11.2.0.3, apply patch for Bug 11837095, This Bug is already fixed in 11.2.0.4

If patch is not available then please raise SR with Oracle Support.


Add the following even in spfile or pfile.

event="10795 trace name context forever, level 2"



No comments:

Oracle 19c - patch 19.22 unavailability for Windows platform

 Oracle 19c - patch 19.22 unavailability for Windows platform  Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 whi...