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


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:
> 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

Other related posts: