oracle11g破解CPU限制,oracle11g等待事件resmgr:cpu quantum如何解决？

引用MOS文档，主要是由于BUG引起，可进过评估，备份后，打上最新的PSU，再观察。

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.2.0.3 [Release 10.2 to 11.2]

Information in this document applies to any platform.

NOTE:

A complete list of patches required to address this problem is maintained by the resource manager product team in

Note 1339803.1 - Recommended Patches for CPU Resource Manager

SYMPTOMS

High waits on wait event 'resmgr:cpu quantum', while there is no CPU load on the host.

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total CallTime WaitClass

resmgr:cpu quantum 247074 4036 16 58.3 Scheduler

CPU time 3201 46.3

log file sync 225905 808 4 11.7 Commit

db file sequential read 95930 650 7 9.4 User I/O

log file parallel write 235251 569 2 8.2 System I/O

**CAUSE**

Related software defects :

Bug 8221960 - WAITS FOR "RESMGR CPU QUANTUM"

Bug 7527260 - HIGH WAIT EVENTS ON "RESMGR CPU QUANTUM" WHEN RESOURCE MANAGER IS ENABLED

Unpublished

Bug 10326338 - HIGH RESMGR:CPU QUANTUM WITH APPSQOS_PLAN IN PLACE

Bug 7510766 - RESOURCE MANAGER IS OVER THROTTLING

Bug 8660422 - "unspecified wait event" and/or "ksfd: async disk IO" after applying patches that include fix for Bug 7510766

Bug 6874858 - Poor performance with Resource Manager when RMAN is running

Bug 16392079 -SESSIONS HANG. WAITING FOR 'RESMGR:CPU QUANTUM'

**SOLUTION**

Bug 8221960 - WAITS FOR "RESMGR CPU QUANTUM"

One-off patches available Patch 8221960

Bug 7510766 - RESOURCE MANAGER IS OVER THROTTLING

Fixed in 11g Release2 and included in patchset 10.2.0.5

The fix of Bug 7510766 can cause a regression (Bug 8660422 - "unspecified wait event" and/or "ksfd: async disk IO" after applying patches that include fix for Bug 7510766) Apply Patch 8660422

Unpublished

Bug 10326338 - HIGH RESMGR:CPU QUANTUM WITH APPSQOS_PLAN IN PLACE

One-off patches available Patch 10326338

Bug 7527260 - HIGH WAIT EVENTS ON "RESMGR CPU QUANTUM" WHEN RESOURCE MANAGER IS ENABLED

Fixed in patchset 10.2.0.4

Workaround by setting the parameters :

_enable_NUMA_optimization=FALSE

_db_block_numa=1

Bug 6874858 - Poor performance with Resource Manager when RMAN is running

Fixed in 11g Release2 and included in patchset 10.2.0.5 and 11.1.0.7

Workaround:

Disable Resource Manager.

One-off patches available Patch 6874858

Bug 16392079 -SESSIONS HANG. WAITING FOR 'RESMGR:CPU QUANTUM'

Fixed in 11.2.0.4 and 12.1.0.1

See also

Note 759503.1 Resource Manager Plan Changes Settings Every Week

which might be causing higher waits on 'RESMGR: ' events due to the changed Resource Plan.

======================================================