RE: enq: TX - index contention

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Tue, 22 Mar 2005 12:08:39 -0600
Message-ID: <D44DCE7BBC084E4C9E2DA87EC75E8DE3348844@pscdalpexch02.perotsystems.net>

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

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=20
PCTUSED: 40=20
INITRANS: 1=20

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]=20 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.

--=20

Best Regards,
K Gopalakrishnan=20
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:11:44 CST