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-32141: get method does not match the type of the parameter

1 Answers  


SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor

1 Answers  


DRG-12441: counting the number of highlights failed

1 Answers  


ORA-06003: NETASY: port write failure

1 Answers  


RMAN-06491: controlfile autobackup format "string" contains more than one "string" format specifier

1 Answers  






SQL*Loader-00420: unsupported datatype conversion requested for column string in table string

1 Answers  


LFI-00137: Unable to perform string on a file object that is string.

1 Answers  


ORA-28575: unable to open RPC connection to external procedure agent

1 Answers  


ORA-14609: Tablespace was not specified for the previous lob segments of column string in template but is specified for string

1 Answers  


RMAN-06467: could not translate DBA: number

1 Answers  


TNS-00090: * Interchange - will ask the Interchange

1 Answers  


ORA-28044: unsupported directory type

1 Answers  


Categories