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.
Matthew D. Heilman <matthew.d.heilman_at_ac.com> wrote in article
<356d731600000005_at_news.accincy.com-MINC>...
> This number determines that number of users that can concurrently have a
> transaction on the table.
>
>
> 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?
> >
> >Thx in advance.
> >
> >Umar.
> >
> >
>
>
>
Received on Thu May 28 1998 - 10:19:25 CDT
