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

LPX-00283: document encoding is ~s-based but default input encoding is not

1 Answers  


ORA-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.

1 Answers  


ORA-02206: duplicate INITRANS option specification

1 Answers  


DRG-10103: illegal value for argument: string

1 Answers  


ORA-02227: invalid cluster name

1 Answers  






NNO-00326: server statistic counter dump follows

1 Answers  


ORA-16640: CRS warns that multiple instances may still be running.

1 Answers  


NID-00425: Database name restored to string.

1 Answers  


RMAN-03001: recovery manager command sequencer component initialization failed

1 Answers  


PLS-00393: wrong number of columns in SELECT...INTO statement

1 Answers  


RMAN-08585: copying standby controlfile

1 Answers  


ORA-14023: creation of GLOBAL partitioned cluster indices is not supported

1 Answers  


Categories