ORA-29356: These parameters can be specified only for
directives that refer to consumer groups



ORA-29356: These parameters can be specified only for directives that refer to consumer groups..

Answer / guest

Cause: The below parameters were specified as an argument to
procedure CREATE_PLAN_DIRECTIVE or UPDATE_PLAN_DIRECTIVE of
package DBMS_RESOURCE_MANAGER.where the GROUP_OR_SUBPLAN
argument is a resource plan. "ACTIVE_SESS_POOL_P1",
"QUEUEING_P1", "PARALLEL_DEGREE_LIMIT_P1", "SWITCH_P1",
"SWITCH_P2", "SWITCH_P3", "MAX_EST_EXEC_TIME", "UNDO_POOL"

Action: Specify these parameters only for consumer group
directives.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24374: define not done before fetch or execute and fetch

2 Answers  


ORA-19300: Error occurred in uri processingstring

1 Answers  


ORA-16594: %s process discovered that DMON process does not exist

1 Answers  


TNS-01029: Services Summary...

1 Answers  


TNS-12582: TNS:invalid operation

1 Answers  






ORA-16511: messaging error using ksrget

1 Answers  


ORA-12416: policy string not found

1 Answers  


ORA-12825: explicit degree of parallelism must be specified here

1 Answers  


ORA-00037: cannot switch to a session belonging to a different server group

1 Answers  


ORA-25222: enqueue failed, complete sender info. not provided for a queue supporting non-repudiation

1 Answers  


DRG-11435: primary key value is invalid

1 Answers  


ORA-28020: IDENTIFIED GLOBALLY already specified

1 Answers  


Categories