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

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/clauses8a.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.
Received on Thu Oct 30 2003 - 13:05:06 CST