Oracle Error ORA-00099: timed out while waiting for resource, potential PDML deadlock

Oracle Error Message

ORA-00097: use of Oracle SQL feature not in SQL92 compliance level

Reason for the Error

The transaction’s required resource was unavailable. The PDML transaction was unable to acquire the resource within the time frame specified. This indicates a potential deadlock involving this PDML transaction and other current system transactions.

Solution

Retry the operation after increasing the value of the PARALLEL TRANSACTION RESOURCE TIMEOUT parameter.