Re: enq: TX - index contention

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Wed, 23 Mar 2005 00:08:25 +0530
Message-ID: <3b0f44a1050322103827bdbf0d@mail.gmail.com>

Les:

Forgot to mention.That note is very old, written based on Oracle 8. As Mark pointed in the ealier message, 2 ITLs created/block from oracle 9 onwards.

On Wed, 23 Mar 2005 00:05:00 +0530, K Gopalakrishnan <kaygopal_at_gmail.com> wrote:
> Les:
>
> I think you are totally confused here. ITLs work at block level. Not
> at segment level. Just for your understanding about ITLs and
> Datablocks /transactions have a look at this note.
> http://www.revealnet.com/newsletter/Transaction%20Management.htm
>
>
> --

-- 

Best Regards,
K Gopalakrishnan 
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 22 2005 - 13:42:09 CST