Database Administration (MOSC)

MOSC Banner

resmgr:cpu quantum Error

edited Aug 6, 2013 1:42PM in Database Administration (MOSC) 3 commentsAnswered
 Hi All,

Two months back i have fired the below comments in my RAC database.

 

****************************************************************************************************

SQL> alter system set resource_manager_plan='' scope=spfile;

****************************************************************************************************

SQL> execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN','');

PL/SQL procedure successfully completed.

SQL> execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

PL/SQL procedure successfully completed.


****************************************************************************************************


SQL> select window_name from DBA_SCHEDULER_WINDOWS;

WINDOW_NAME
------------------------------
MONDAY_WINDOW
TUESDAY_WINDOW
WEDNESDAY_WINDOW
THURSDAY_WINDOW
FRIDAY_WINDOW
SATURDAY_WINDOW
SUNDAY_WINDOW
WEEKNIGHT_WINDOW
WEEKEND_WINDOW

9 rows selected.

 

****************************************************************************************************


SQL> execute dbms_scheduler.set_attribute('MONDAY_WINDOW','RESOURCE_PLAN','');

PL/SQL procedure successfully completed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center