| 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>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
