SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

S567Jul 6 2020 — edited Jul 8 2020

Hello experts,

I am working on oracle 11 g DB.

I am executing one of my proc and getting this error which i am not much aware of i t.

When i google to see how to take action on this what i notice is below..

Action: increase MAXTRANS of the block or reduce the degree of parallelism for the statement. Reexecute the statement.

How to know on which table it is getting locked.

May i know how to increase the MAXTRANS - Is it something that i have to increase the block size or table space ?

Thanks,

Added on Jul 6 2020

29 comments

1,817 views