Oracle Solution for Error ora-29388

ORA-29388: plan/consumer_group string is part of more than one top-plan

What triggered the Error:

attempt was made to delete a subtree that includes a plan or consumer group that is part of more than one top-plan as part of procedure DELETE_PLAN_CASCADE or package DBMS_RESOURCE_MANAGER. Such a plan or consumer group cannot be deleted.

What should we do to fix it:

eck the ancestors of the plan or consumer group and make sure it is only part of the top-plan that includes the subtree being deleted.