Oracle Solution for Error ora-12829

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

What triggered the Error:

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

What should we do to fix it:

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.