Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to determine cause of deadlock
I have seen many references to INITRANS but have yet to find an explantion that I can understand. Can someone explain what this setting does? Thanks.
On Fri, 14 Jul 2000 08:43:21 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>You can get 'no row' deadlocks when the INITRANS
>value on a table is too low. If the block is full and has
>INITRANS=1, and you get two processes trying to
>change the block, then the second has to wait for
>the first to commit so that it can acquire the 'ITL'
>(interested transaction list) slot. This is a little
>unlikely with inserts only.