Re: INITRANS and MAXTRANS

From: Umar FArooq <umar.farooq_at_cressoft.com.pk>
Date: Fri, 29 May 1998 12:54:28 +0500
Message-ID: <356E69B4.DD1C7291@cressoft.com.pk>

yes..but why does Oracle need space in the block...how does it use it.....could anyone give me the specifics of the mechanism involved

thx.

Umar.

Mark Powell wrote:

> The reason that initrans and maxtrans apply to each block is that
> Oracle
> maintains row level locking information at the block level and not in
> the
> SGA or in a system lock table. Each update process needs a
> work/record
> area in the same block as the rows it is affecting.
>

>
> > Umar FArooq wrote in message <356CFA80.D51A723F_at_cressoft.com.pk>...
> > >HI!'
> > >Could anyone tell me the purpose of INITRANS and MAXTRANS. The
> ORacle
> > >documentation says that they specify the space for an initial and
> max
> > >number of transactions that can occupy a block. What does this mean
> and
> > >what is the need to reserve space for transactions in each block?
>
Received on Fri May 29 1998 - 02:54:28 CDT