Re: INITTRANS parameter settings

From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Date: Mon, 6 Nov 2000 15:53:09 -0800 (PST)
Message-Id: <10672.121261@fatcity.com>

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!? Received on Mon Nov 06 2000 - 17:53:09 CST