Oracle Error ORA-29379: resource plan string is involved in a loop in top-plan string

Oracle Error Message

ORA-29379: resource plan string is involved in a loop in top-plan string

Reason for the Error

A loop was discovered while validating a top-plan.

Solution

Check the plans that have the specified plan as a GROUP_OR_SUBPLAN, and remove the plan directive that causes the loop.