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

Hi,

You can see Scheduler wait event in Performance page of Oracle Enterprise Manager Cloud Control 13c.

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

 

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>

 

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

Mehmet Salih Deveci

I am Founder of 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 mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *