Link to home
Start Free TrialLog in
Avatar of imran_fast
imran_fast

asked on

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
SOLUTION
Avatar of sonicefu
sonicefu
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of imran_fast
imran_fast

ASKER

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

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial