How to Solve resmgr:cpu quantum ( resource_manager_cpu_allocation ) Wait Event in Oracle 12c

You can see resmgr:cpu quantum ( resource_manager_cpu_allocation ) wait event in Performance page of Oracle Enterprise Manager Cloud Control 13c.

 

resmgr:cpu quantum ( resource_manager_cpu_allocation ) Wait Event

When I take AWR ( Automatic Workload Repository ) report, I saw that There are resmgr:cpu quantum Wait Event in AWR.

 

resource_manager_cpu_allocation

To solve this problem, I have changed resource_manager_plan and cpu_count parameters like following.

 

SQL> show parameter resource

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_limit boolean TRUE
resource_manager_cpu_allocation integer 56
resource_manager_plan string SCHEDULER[0x444D]:DEFAULT_MAIN
TENANCE_PLAN
SQL>


SQL> alter system set resource_manager_plan='' scope=both sid='*';

System altered.

SQL>
SQL>
SQL> show parameter resource

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_limit boolean TRUE
resource_manager_cpu_allocation integer 56
resource_manager_plan string
SQL>
SQL>

SQL> show parameter cpu

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 8
parallel_threads_per_cpu integer 2
resource_manager_cpu_allocation integer 56
SQL>
SQL>


SQL> alter system set cpu_count=32 scope=both sid='*';

System altered.

SQL> show parameter cpu

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 32
parallel_threads_per_cpu integer 2
resource_manager_cpu_allocation integer 56
SQL>
SQL>

 

cpu_count parameter

I have increased cpu_count parameters from 8 to 32 then Scheduler and  resmgr:cpu quantum Wait Event are disappeared.

 

 

 

Do you want to learn Oracle Database Performance Tuning detailed, then Click this link.

 1,249 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

4 comments

  1. Does your system have 8 or 32 cpu? If you only have 8 how would that solve the problem? Wouldnt that stress the server?

  2. Thanks for the fast reply. You mean increase CPU on the server?

Leave a Reply

Do NOT follow this link or you will be banned from the site!