Re: enq: TX - index contention

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Tue, 22 Mar 2005 23:50:57 +0530
Message-ID: <3b0f44a105032210207e7875fc@mail.gmail.com>

Les:

Sorry you have to buy that as that is the truth. All the documentations and references you mention are wrong. Sorry I am at home now and I don't have a database to demonstrate that. It is very simple to test.

Just create a table and dump few blocks. You will see 2 ITLs ( It will be visible in block dump, if you have difficulties in reading blockdump just grep for 'itc' in the trace file. This will show the ITL count.

>
> And I guess ALL of Oracle's Documentation is wrong......Training courses
> both 9.0 and 9.2, The Online documentation for create table which
> contains THIS:
>
> If you omit this clause, then Oracle uses the following default values:
>
> PCTFREE: 10
> PCTUSED: 40
> INITRANS: 1
> MAXTRANS: Depends on data block size
>
> AND the Oracle Press Oracle 9i DBA Handbook on page 881 under create
> table....
>
> You're telling me that ALL of that documentation PLUS the actual results
> of a select statement are wrong.
>
> Not buying it.

-- 

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:24:31 CST