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

LFI-00133: Trying to create file string that already exists.

1 Answers  


ORA-16755: failed to set initialization parameter

1 Answers  


ORA-26718: transaction limit reached

1 Answers  


ORA-16064: remote archival is disabled by another instance

1 Answers  


RMAN-06510: RMAN retention policy is set to recovery window of number days

1 Answers  






ORA-07804: slpdtb: number too large for supplied buffer

1 Answers  


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

1 Answers  


ORA-09938: Save of signal handlers failed.

1 Answers  


ORA-07614: $CHANGE_CLASS failed in retrieving the user's process label

1 Answers  


ORA-24275: function 'string' parameter 'string' missing or invalid

1 Answers  


LFI-00104: Read operation failed.

1 Answers  


ORA-03200: the segment type specification is invalid

1 Answers  


Categories