How to fix the Oracle error ORA-29360: resource plan string contains multiple directives for subplan string?

In this post, you’ll learn more about the Oracle ErrorORA-29360: resource plan string contains multiple directives for subplan string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-29360: resource plan string contains multiple directives for subplan string

Reason for the Error ORA-29360: resource plan string contains multiple directives for subplan string

A resource plan and its subplans had more than one directive for a particular subplan.

How to fix the Error ORA-29360: resource plan string contains multiple directives for subplan string ?

You can fix this error in Oracle by following the below steps

Modify the resource plan or its subplans so that there is at most one directive for this subplan.