Message-Id: <10672.121230@fatcity.com> From: "Tom Pall" Date: Mon, 6 Nov 2000 12:32:00 -0600 Subject: Re: INITTRANS parameter settings This is a multi-part message in MIME format. ------=_NextPart_000_0F90_01C047ED.8F4FD950 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: INITTRANS parameter settingsQuite right. I intended to mention = parallel but got distracted then forgot. ----- Original Message -----=20 From: Alex Hillman=20 To: Multiple recipients of list ORACLE-L=20 Sent: Monday, November 06, 2000 12:15 PM Subject: 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=20 -----Original Message-----=20 From: Tom Pall [mailto:tom@cdproc.com]=20 Sent: Monday, November 06, 2000 11:46 AM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Re: INITTRANS parameter settings=20 Initrans defines the inital number of 43 byte interested transaction = list (ITL)=20 entries originally allocated in the data block. Maxtrans defines the = maximum=20 number of ITLs a block can have.=20 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.=20 Once an ITL is created, its space cannot be reused for row data. =20 Having initrans/maxtrans higher than needed for concurrency wastes = block space.=20 ----- Original Message -----=20 To: Multiple recipients of list ORACLE-L =20 Sent: Monday, November 06, 2000 8:50 AM=20 > Our client has a table which will have over 200=20 > updates and 100 inserts every second. Should I leave=20 > the default setting for inittrans or should I increase=20 > the value of this parameter. Can someone shed some=20 > light on this issue.=20 >=20 > Thanks=20 > Sonia P.=20 >=20 > __________________________________________________=20 > Do You Yahoo!?=20 > Thousands of Stores. Millions of Products. All in one Place.=20 > http://shopping.yahoo.com/=20 > --=20 > Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 > --=20 > Author: sonia pajerowski=20 > INET: spajerowski@yahoo.com=20 >=20 > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 > San Diego, California -- Public Internet access / Mailing = Lists=20 > -------------------------------------------------------------------- = > To REMOVE yourself from this mailing list, send an E-Mail message=20 > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in=20 > the message BODY, include a line containing: UNSUB ORACLE-L=20 > (or the name of mailing list you want to be removed from). You may=20 > also send the HELP command for other information (like subscribing). = --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author: Tom Pall=20 INET: tom@cdproc.com=20 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing Lists = --------------------------------------------------------------------=20 To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20 ------=_NextPart_000_0F90_01C047ED.8F4FD950 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: INITTRANS parameter settings
Quite right.  I intended to mention parallel = but got=20 distracted then forgot.
----- Original Message -----
From:=20 Alex=20 Hillman
To: Multiple recipients of list ORACLE-L =
Sent: Monday, November 06, 2000 = 12:15=20 PM
Subject: RE: INITTRANS = parameter=20 settings

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

Alex Hillman

-----Original Message-----
From: Tom=20 Pall [mailto:tom@cdproc.com]=20
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=20 transaction list (ITL)
entries originally = allocated in=20 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=20 row locks.
If one session at a time is doing = DML,=20 multiple ITLs won't speed things up.
Once an = ITL is=20 created, its space cannot be reused for row data.  =
Having initrans/maxtrans higher than needed for concurrency = wastes=20 block space.


----- Original Message -----
To:=20 Multiple recipients of list ORACLE-L = <ORACLE-L@fatcity.com>=20
Sent: Monday, November 06, 2000 8:50 AM =


> Our client has a table which will have over = 200=20
> updates and 100 inserts every second. Should I = leave
> the default setting for inittrans = or should=20 I increase
> the value of this parameter. = Can=20 someone shed some
> light on this = issue.=20
>
> Thanks =
> Sonia P.
>
>=20 __________________________________________________
> Do You Yahoo!?
> Thousands = of=20 Stores.  Millions of Products.  All in one Place. =
> http://shopping.yahoo.com/
> --=20
> Please see the official ORACLE-L FAQ: = http://www.orafaq.com=20
> --
> Author: = sonia=20 pajerowski
>   INET:=20 spajerowski@yahoo.com
>
> Fat City Network Services    -- (858)=20 538-5051  FAX: (858) 538-5051
> San = Diego,=20 California        -- Public = Internet access=20 / Mailing Lists
>=20 = --------------------------------------------------------------------=20
> To REMOVE yourself from this mailing list, = send an=20 E-Mail message
> to: ListGuru@fatcity.com = (note=20 EXACT spelling of 'ListGuru') and in
> = the message=20 BODY, include a line containing: UNSUB ORACLE-L
>=20 (or the name of mailing list you want to be removed from).  You=20 may
> also send the HELP command for = other=20 information (like subscribing).

--
Please see the official = ORACLE-L=20 FAQ: http://www.orafaq.com
-- =
Author: Tom Pall
  INET:=20 tom@cdproc.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San = Diego,=20 California        -- Public = Internet access=20 / Mailing Lists
----------------------------------------------------------------= ----=20
To REMOVE yourself from this mailing list, send an = E-Mail=20 message
to: ListGuru@fatcity.com (note EXACT = spelling=20 of 'ListGuru') and in
the message BODY, = include a line=20 containing: UNSUB ORACLE-L
(or the name of = mailing=20