RE: enq: TX - index contention

OK cut from the very document you referred me to states =20

A transaction, which modifies a record in the datablock, must get an ITL slot in that datablock. The number of ITL slots in a datablock is defined by the INITRANS (which defaults 1 for data blocks and 2 for index blocks) and MAXTRANS.

So, what I said earler coincides with the web page you referred me to.

Oracle creates a table with a DEFAULT 2 datablocks.

Oracle creates an index with a DEFAULT 5 datablocks

Based on your setting (OR lack thereof) for inittrans in your create statement, Oracle will allocate 1 inittrans (ITL) for each BLOCK in the segment. Default or NO entry will give you ONE inittrans for EACH BLOCK and I will repeat here that AGAIN by default you get 2 blocks for a create table statement unless you specify a bigger initial size and or are using Locally Managed Tablespaces (so there is no confusion as to what I meant by LMT)

So, what I am saying is agreement with the URL I pasted to me.

Which means that again the documentation is right.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan Sent: Tuesday, March 22, 2005 12:35 PM
To: Hollis, Les
Cc: Powell, Mark D; oracle-l_at_freelists.org Subject: Re: enq: TX - index contention

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

--=20

Best Regards,
K Gopalakrishnan=20
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 22 2005 - 13:51:40 CST