Home » RDBMS Server » Server Administration » Can't activate resource plan
Can't activate resource plan [message #185370] Tue, 01 August 2006 07:04
kovacsb
Messages: 1
Registered: August 2006
Junior Member
Hello,

I changed the default SYSTEM_PLAN to allow only 15% CPU for the LOW_GROUP. I could submit the pending area without any problem and set the resource plan to SYSTEM_PLAN.

The problem is that the STATUS is always empty (Neither ACTIVE nor PENDING). What did I miss?

That's what I have at the moment:
SQL> show parameter resource; 

NAME TYPE VALUE 
------------------------------------ -------------------------------- ------------------------------ 
resource_limit boolean TRUE 
resource_manager_plan string SYSTEM_PLAN 
SQL> 
SQL> SELECT plan,group_or_subplan,cpu_p1,cpu_p2,cpu_p3, status from dba_rsrc_plan_directives; 

PLAN GROUP_OR_SUBPLAN CPU_P1 CPU_P2 CPU_P3 STATUS 
------------------------------ ------------------------------ ---------- ---------- ---------- ------------------------------ 
SYSTEM_PLAN SYS_GROUP 100 0 0 
SYSTEM_PLAN OTHER_GROUPS 0 100 0 
SYSTEM_PLAN LOW_GROUP 0 0 15 
INTERNAL_QUIESCE SYS_GROUP 0 0 0 
INTERNAL_QUIESCE OTHER_GROUPS 0 0 0 
INTERNAL_PLAN OTHER_GROUPS 0 0 0 

6 rows selected. 

SQL> select consumer_group,status from dba_rsrc_consumer_groups; 

CONSUMER_GROUP STATUS 
------------------------------ ------------------------------ 
OTHER_GROUPS 
DEFAULT_CONSUMER_GROUP 
SYS_GROUP 
LOW_GROUP 
AUTO_TASK_CONSUMER_GROUP 

SQL>

Previous Topic: Business Objects Repository TableSpace issue
Next Topic: PK FK and constraints in Materialized Views
Goto Forum:
  


Current Time: Sat Dec 03 09:40:50 CST 2016

Total time taken to generate the page: 0.05740 seconds