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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Powell, Mark D
Sent: Tuesday, March 22, 2005 12:44 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxx]
Sent: Tuesday, March 22, 2005 1:09 PM
To: K Gopalakrishnan
Cc: mark.powell@xxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Tuesday, March 22, 2005 11:56 AM
To: Hollis, Les
Cc: mark.powell@xxxxxxx; oracle-l@xxxxxxxxxxxxx
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