Please Check VKTM Trace File for More Details (文件 ID 1347586.1)
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.
Goal
Below message keeps repeating in Alert-log.
This note explains the possible cause and if the issue needs to be addressed or not.
Solution
There are multiple bugs filed for this issue, Some of them follows:
Bug 12374867 - TIME DRIFT DETECTED. PLEASE CHECK VKTM TRACE FILE FOR MORE DETAILS.
Which were closed as duplicates of:
To fix the issue, please download and apply patch 11837095 as available for your release/platform. This is available for 11.2.0.2 and above.
Patch 11837095 extends to functionality of event 10795 (set to level 2) for VKTM tracing and limits alert log entries.
After applying the patch, enable event 10795 at level 2:
Then bounce the instance (shutdown then startup) for the event to be applied.
The permanent fix is planned to be included in the 11.2.0.4 and 12.1 releases.
Meaning and technical Impact of the error:
If the traces are emitting time drifts of amount beyond these ranges, then it needs to be analyzed.
Most of the times, during high loads, there would be issues with underlying OS due to virtual memory, network time protocol improper configuration etc.
In general VKTM process need to be scheduled in every 10ms, if due to above reasons this is not happening we see the time drifts and to certain level (mentioned above) are permissible.
Eventually, this probably would cause the resource manager to take improper decisions and can lead to a hang in worst case.
Unpublished Bug 18390507 : EXADATA: VKTM CONSUMING HUGE CPU AFTER PATCHING 11.2.3.3.0 AND 11.2.0.4.3
This Bug is closed as duplicate of Unpublished Bug 18499306
Unpublished Bug 18499306 : DBMX28 DATABASE VKTM PROCESSES CONSUME LARGE AMOUNT OF CPU, UNSTABLIZE MACHINE
This Bug is fixed in 12.2
So please download & apply patch 18499306, if its available on top of your database version for your platform
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13750068/viewspace-1672708/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Unable to list target platforms. Please make sure the android sdk path is correct. See the Console for more details.PlatformAndroidAI
- ORA-00205: error in identifying control file, check alert log for more infoErrorIDE
- SEGMENT SHRINK and Details. (文件 ID 242090.1)AI
- AAPT2 error: check logs for detailsAPTErrorAI
- Android Studio錯誤處理Plugin is too old, please update to a more recent versionAndroidPlugin
- 【metalink】Export/Import DataPump Parameter TRACE (文件 ID 286496.1)ExportImport
- Details on individual partitionsAI
- [Oracle Script] check File I/OOracle
- Please add or free up more resources then turn off safe mode manually.
- sql_trace生成及使用tkprof檢視trace fileSQL
- More than one file was found with OS independent path
- oracle監聽開啟trace fileOracle
- How to Check and Enable/Disable Oracle Binary Options (文件 ID 948061.1)Oracle
- TECH: Getting a Stack Trace from a CORE file on Unix (Doc ID 1812.1)
- Please provide a valid cache pathIDE
- 從v$diag_info定位trace file
- ORA-01157: cannot identify/lock data file %s - see DBWR trace file的處理IDE
- Android Bugs——Error:java.lang.RuntimeException: Some file crunching failed, see logs for detailsAndroidErrorJavaExceptionAI
- Android Gradle Build Error:Some file crunching failed, see logs for details解決辦法AndroidGradleUIErrorAI
- Process W000 died, see its trace file
- How to read Oracle 10046 trace fileOracle
- 如何收集用來診斷效能問題的10046 Trace(SQL_TRACE) (文件 ID 1523462.1)SQL
- 解決Error Initialization failed for ‘https://start.spring.io‘Please check URL, nErrorAIHTTPSpring
- ERROR: Check /etc/pam.conf file permissions and ownershipError
- 10.2.0.2 RAC DB ">>> ERROR IN KQLMBIVG SEE LCK TRACE FILEError
- oracle deadlock死鎖trace file分析之一Oracle
- Unable to execute dex: java.nio.BufferOverflowException. Check the Eclipse log for stack trace.JavaExceptionEclipse
- mha_replication_check Can't exec "mysqlbinlog": No such file or directoryMySql
- contains a file system with errors, check forced解決方法AIError
- Log check error: Log file /var/log/messages is not readable!Error
- 監聽器控制程式lsnrctl跟蹤trace file
- truncate、recreate後臺程式跟蹤檔案(trace file)
- nagios使用check_oracle_health配置文件iOSOracle
- Log Write Methods can Cause 'log file sync' Waits (文件 ID 1462942.1)AI
- Non critical error ORA-48913 caught while writing to trace fileErrorWhile
- oracle deadlock死鎖trace file分析之一增補Oracle
- OERR: ORA-1499 table/Index Cross Reference Failure - see trace file [ID 1499.1]IndexROSAI
- Check mod for temporary file : /usr/local/centreon/var/lib/centplugins/Plugin