Wait Event: resmgr:cpu quantum

Database; Oracle 10G R2
I check the weekend windows group in the resource manager it was scheduled to run on saturday i changed it to run on thursday and still the activity screen in performace tab of enterprise manager show high activity in the scheduler group.

I saw that no job is running but still it shows high activity for scheduler
Wait Event: resmgr:cpu quantum is too high today and the system is getting slow what can i do to stop this scheduler wait event.

Please advice
LVL 28
imran_fastAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sonicefuCommented:
The resmgr: cpu quantum wait event occurs when a process is waiting to be scheduled by Resource
Manager

A high number of occurrences of this event under load does not indicate performance degradation. It is
analogous to counting time spent on the OS queue.

Other wait events may indicate problems that would affect Resource Manager adherence to the plan

what is the output of the following query

select consumer_group_name, cpu_wait_time,
consumed_cpu_time from v$rsrcmgrmetric_history

Open in new window

0
imran_fastAuthor Commented:
Fixed

using below code i close the window which was active.
BEGIN
    DBMS_SCHEDULER.CLOSE_WINDOW(
         window_name => 'WEEKEND_WINDOW'
    );
END;
/

Open in new window

0
sonicefuCommented:
good, imran

you are really fast !

Ajmal
0
sonicefuCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.