My Oracle Support Banner

High Resmgr:Cpu Quantum Wait Events In Standard Edition Oracle Database on Amazon Web Services (Doc ID 2381153.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Statspack reports:


Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
resmgr:cpu quantum                             268,460      17,441     65   79.3
CPU time                                                     3,494          15.9
log file parallel write                         17,226         163      9     .7
log file sequential read                        12,823         154     12     .7
db file sequential read                         50,938         146      3     .7
         -------------------------------------------------------------
 SQL> SELECT * FROM V$OSSTAT;

STAT_NAME                            VALUE
------------------------------ -----------
NUM_CPUS                                 2 *<<<<----
IDLE_TIME                        708965289
BUSY_TIME                         44222808
USER_TIME                          7171195
SYS_TIME                           4418388
IOWAIT_TIME                        5521679
NICE_TIME                         31636979 *<<<<----
RSRC_MGR_CPU_WAIT_TIME            13252256

For example, as following, average foreground process running count is 2.30, and average average foreground process waiting for CPU is 21.30:  

*** 2018-03-26 12:12:05.095
cpu%:     cputm:      cpuwt:    avgrun:    avgwt:
98      149577     1198969       2.30     21.30 

  

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.