环境是Centos6.9+11.2.0.4.180417上,存在VKRM的trace文件,内容如下
*** 2019-03-03 06:00:00.135 *** SESSION ID:(1291.44003) 2019-03-03 06:00:00.135 *** CLIENT ID:() 2019-03-03 06:00:00.135 *** SERVICE NAME:(SYS$BACKGROUND) 2019-03-03 06:00:00.135 *** MODULE NAME:() 2019-03-03 06:00:00.135 *** ACTION NAME:() 2019-03-03 06:00:00.135 VKRM scheduling interval:(10)ms VKRM uses high resolution time: last active time=(1551549600010253) current time=(1551564000135405) _history_rest_time=(10)sec *** 2019-03-04 02:00:00.021 VKRM ends at (1551636000020685)
该问题在MOS上找到文档,提示说在11.2.0.3版本上已修复
Patch suggestions for Bug:9382956 You have indicated that you are on 11.2.0.4 (Server Patch Set) *but* this bug is marked as fixed in 11.2.0.3 (Server Patch Set) onwards. ie: It looks like you already have the fix for this bug. Due to this I cannot suggest any patch options. Please review Bug:9382956 and re-check details of the problem.
理论上,可以通过以下修复该问题 Patch 9382956: VKRM TRACE FILES GENERATED WHEN RESOURCE MANAGER PLAN IS CLEARED
该问题,现未影响到生产运行,没有打该补丁