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

Oracle Error Message

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

Reason for the Error

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

Solution

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.