Showing posts with label ORA-12829. Show all posts
Showing posts with label ORA-12829. Show all posts

Saturday, 3 March 2012

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

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.