In this post, you’ll learn more about the Oracle ErrorORA-29384: number of consumer groups and subplans for plan string exceeds string with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-29384: number of consumer groups and subplans for plan string exceeds string
Reason for the Error ORA-29384: number of consumer groups and subplans for plan string exceeds string
An attempt was made to create or modify the specified plan, but the plan has more than 28 consumer groups or subplans.
How to fix the Error ORA-29384: number of consumer groups and subplans for plan string exceeds string ?
You can fix this error in Oracle by following the below steps
Make sure the specified plan points to no more than 28 distinct consumer groups or subplans.