RE: enq: TX - index contention

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Tue, 22 Mar 2005 12:50:13 -0600
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C5331C8C0@CWYMSX06.Corp.Acxiom.net>

Steve Adams told me that last year, that is, 9i defaults to 2 regardless of what the catalog says.

Larry

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D
Sent: Tuesday, March 22, 2005 12:44 PM
To: oracle-l_at_freelists.org
Subject: 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

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

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 22 2005 - 13:53:56 CST