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

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/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.
>>
>>

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)