How to fix the Oracle error ORA-29356: These parameters can be specified only for directives that refer to consumer groups?

In this post, you’ll learn more about the Oracle ErrorORA-29356: These parameters can be specified only for directives that refer to consumer groups with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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”

How to fix the Error ORA-29356: These parameters can be specified only for directives that refer to consumer groups ?

You can fix this error in Oracle by following the below steps

Specify these parameters only for consumer group directives.