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:
Post a Comment