Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Load on my 11g RAC looks like this:

enter image description here

and I don't understand how to get insight into what this "scheduler" wait class is. It seems like "scheduler" that it refers to is the process that runs scheduled maintenance jobs? But can I see which jobs they are? All I see is normal queries waiting for the "scheduler".

The wait even class is "resmgr: cpu quantum"

share|improve this question

2 Answers 2

up vote 2 down vote accepted

They are Oracle Resource Manager waits. Resource Manager is a set of Oracle functionality that lets you prioritise work.

See the list of possible waits in the documentation.

share|improve this answer

It looks like resource manager is in action. Your dba configured this most likely to give certain processes priority over other processes. Oracle Scheduler is fuly integrated with Resource Manager but the way this is presented is a bit misleading. Often it has nothing to do with Scheduled Jobs at all. You can find which sessions are waiting for resource manager by checking v$session:

select sid, serial#, username, resource_consumer_group from v$session
where event like 'resmgr%'

Resource Consumer Group membership of a session determines what priority a session gets. Resource Manager is a very powerful way to manage load on a system to make sure that important processes can finish in their designated time. Maybe your sessions are not mapped to the correct Resource Consumer Group.

Your dba needs good info about business priorities to be able to make a correct Resource Plan.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.