Oracle Error ORA-29384: number of consumer groups and subplans for plan string exceeds string

Oracle Error Message

ORA-29384: number of consumer groups and subplans for plan string exceeds string

Reason for the Error

An attempt was made to create or modify the specified plan, but the plan has more than 28 consumer groups or subplans.

Solution

Make sure the specified plan points to no more than 28 distinct consumer groups or subplans.