Yup, I got the number wrong.
It didn't look completely right when I typed it.
Sorry about that.
----- Original Message -----
From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Monday, November 06, 2000 5:55 PM
Subject: 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
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).
> > You may
> > > also send the HELP command for other information (like
> > subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Tom Pall
> > INET: tom_at_cdproc.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
> > You may
> > also send the HELP command for other information (like
> subscribing).
>
>
> =====
> Gaja Krishna Vaidyanatha
> Director, Storage Management Products, Quest Software Inc.
> Office : (972)-304-1170, E-mail : gajav_at_yahoo.com
>
> Author - Oracle Tuning 101 by Osborne McGraw-Hill
> "Opinions and views expressed are my own and not of Quest"
>
> __________________________________________________
> 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: Gaja Krishna Vaidyanatha
> INET: gajav_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Nov 07 2000 - 08:02:24 CST
