Friday, April 23, 2010

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

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.

Action: Increase the value of the PARALLEL_TRANSACTION_RESOURCE_

TIMEOUT parameter; then retry the operation.