Re: Maximum number of transaction. (Newby question).

You can log a documentation bug through the iTar system. I have done this in the past, though it probably won't get changed until 10g release 2 now.

-- 
Niall Litchfield
Oracle DBA
Audit Commission Uk


"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message

news:1067550579.964913_at_yasure...
VC wrote:

Hello Daniel,

I am afraid that the URL you've mentioned will be of little help to
the original poster.  The manual for 9.2
(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses
8a.htm#997633)
claims this:



"INITRANS integer

Specify the initial number of concurrent transaction entries allocated
within each data block allocated to the database object. This value
can range from 1 to 255 and defaults to 1, ..."


However,  the reality is such that, under 8.1.7,  Oracle creates _one_
ITL entry whilst under 9.2.0.3/4 it creates _two_.  The same 'create
table' statement was executed in both cases:

create table t1(x int) initrans 1 maxtrans 1;


Rgds.

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message
news:<1067524891.804022_at_yasure>...

ben brugman wrote:




What am I missing or understanding wrongly.

ben brugman




You are assuming that your interpretation of MINTRANS and MAXTRANS is as
you
think it is. I'd suggest going to http://tahiti.oracle.com and
researching the subject more.

Thanks.

Mark! Mark Townsend! Here's another one that appears to require a bit of
attention.

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)