ORA-00099 timed out while waiting for resource, potential PDML deadlock
Oracle Database Error Code Messages ORA-00099 Description Help About;
Timed out while waiting for resource, potential PDML deadlock.
Problem Error Cause;
The resource needed by the transaction was busy. The PDML transaction could not acquire the resource within the specified amount of time. This indicates potential deadlock involving this PDML transaction and other transactions currently running in the system.
How to Solve;ORA-00099 timed out while waiting for resource, potential PDML deadlock?
Action for Solve Fix Ora-00099;
Increase the value of the PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter; then retry the operation.
