Oracle Error ORA-29380: resource plan string is currently active and cannot be deleted

Oracle Error Message

ORA-29380: resource plan string is currently active and cannot be deleted

Reason for the Error

An attempt was made to delete an active plan in the pending area. No changes can be made to active plans.

Solution

Delete the plan when it is not in use.