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.

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

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.

4 thoughts on “How to Solve resmgr:cpu quantum Wait Event in Oracle 12c

  • December 10, 2019 at 4:07 pm
    Permalink

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

    Reply
  • December 11, 2019 at 12:25 pm
    Permalink

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

    Reply

Leave a Reply

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