Re: enq: TX - index contention
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: "Hollis, Les" <Les.Hollis@xxxxxx>
- Date: Tue, 22 Mar 2005 23:50:57 +0530
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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
