Message-Id: <10672.121227@fatcity.com> From: Alex Hillman Date: Mon, 6 Nov 2000 13:08:15 -0500 Subject: RE: INITTRANS parameter settings This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0481C.88C46720 Content-Type: text/plain; charset="iso-8859-1" I think that even one session can use parallel DML and in this case increase for INITRANS and multiple freelists should help. Alex Hillman -----Original Message----- From: Tom Pall [mailto:tom@cdproc.com] Sent: Monday, November 06, 2000 11:46 AM To: Multiple recipients of list ORACLE-L Subject: Re: INITTRANS parameter settings 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 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@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@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@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@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). ------_=_NextPart_001_01C0481C.88C46720 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: INITTRANS parameter settings

I think that even one session can use parallel DML = and in this case increase for INITRANS and multiple freelists should = help.

Alex Hillman

-----Original Message-----
From: Tom Pall [mailto:tom@cdproc.com]
Sent: Monday, November 06, 2000 11:46 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: INITTRANS parameter settings


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@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@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@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@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@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 =