RE: enq: TX - index contention

There is nothing new about errors appearing in the Oracle documentation. Remember when version 8 and if you read the Concepts, DBA Admin, SQL, and Application Programmers Guide two of the manuals said the maximum number of columns in an index is 16 and two said it was 32. The correct answer was the new value of 32. Two of the manuals had just not been updated for the change.

As for the dictionary view remember that for storage information Oracle often shows you what was requested and not what was actually allocated. For that see dba_segments and dba_extents. Why we get a wrong value for ini_trans I am not really sure; I just know it is wrong.

• Mark D Powell --

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

From: Hollis, Les [mailto:Les.Hollis_at_ps.net] Sent: Tuesday, March 22, 2005 1:09 PM
To: K Gopalakrishnan
Cc: mark.powell_at_eds.com; oracle-l_at_freelists.org Subject: RE: enq: TX - index contention

Then explain to me why a "select ini_trans from user_tables where table_name = 'JUNKY1'; " returns a result of

INI_TRANS

1

On a table I just created

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.

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

From: K Gopalakrishnan [mailto:kaygopal_at_gmail.com] Sent: Tuesday, March 22, 2005 11:56 AM
To: Hollis, Les
Cc: mark.powell_at_eds.com; oracle-l_at_freelists.org Subject: Re: enq: TX - index contention

Les:

The documentation is incorrect. Just do a blockdump and see the ini_trans. It is very simple to test.

--

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:48:47 CST