Oracle database error code ORA-12829 – Deadlock – itls occupied by siblings at block string of file string

Oracle Database Error Code ORA-12829 Description :
Deadlock – itls occupied by siblings at block string of file string
Error Cause:
parallel statement failed because all itls in the current block are occupied by siblings of the same transaction.

How to Solve :
increase MAXTRANS of the block or reduce the degree of parallelism for the statement. Reexecute the statement. Report suspicious events in trace file to Oracle Support Services if error persists.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»