ORA-12829: Deadlock - itls occupied by siblings at block
string of file string



ORA-12829: Deadlock - itls occupied by siblings at block string of file string..

Answer / guest

Cause: parallel statement failed because all itls in the
current block are occupied by siblings of the same transaction.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25295: Subscriber is not allowed to dequeue buffered messages

1 Answers  


ORA-00155: cannot perform work outside of global transaction

1 Answers  


PLS-00992: Cursor Variables cannot be FETCH'ed from

1 Answers   Wipro,


ORA-16411: ONDEMAND archival requires active managed recovery operation

1 Answers  


PCB-00579: Invalid ARRAYLEN length variable type for "string"

1 Answers  






QSM-01073: materialized view, string, has a join not found in query

1 Answers  


LSX-00222: "~1S" is too long (maximum length is ~2d)

1 Answers  


ORA-29843: indextype should support atleast one operator

1 Answers  


SQL*Loader-00931: OCI error while binding variable for column string in table string

1 Answers  


NNL-00988: Non-authoritative NACKs received: number

1 Answers  


SQL-02107: Program too old for runtime library; please re-precompile it

1 Answers  


ORA-24334: no descriptor for this position

2 Answers  


Categories