Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: INITTRANS parameter settings
Tom,
I think there might be a typo here, it is my understanding that each ITL entry is 23 bytes and not 43 bytes, unless this has changed in Oracle 8i. Last time I checked it was 23 bytes.
Cheers,
Gaja
--- Tom Pall <tom_at_cdproc.com> wrote:
> Initrans defines the inital number of 43 byte interested
> transaction list (ITL)
> entries originally allocated in the data block. Maxtrans
> defines the maximum
> number of ITLs a block can have.
>
> ITLs are where each session doing DML on a block places its
> row locks.
> If one session at a time is doing DML, multiple ITLs won't
> speed things up.
> Once an ITL is created, its space cannot be reused for row
> data.
> Having initrans/maxtrans higher than needed for concurrency
> wastes block space.
>
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent: Monday, November 06, 2000 8:50 AM
>
>
> > Our client has a table which will have over 200
> > updates and 100 inserts every second. Should I leave
> > the default setting for inittrans or should I increase
> > the value of this parameter. Can someone shed some
> > light on this issue.
> >
> > Thanks
> > Sonia P.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Thousands of Stores. Millions of Products. All in one
> Place.
> > http://shopping.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: sonia pajerowski
> > INET: spajerowski_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> >
>
Author - Oracle Tuning 101 by Osborne McGraw-Hill "Opinions and views expressed are my own and not of Quest"
![]() |
![]() |