Re: enq: TX - index contention

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

Other related posts: