Re: INITTRANS parameter settings

From: Tom Pall <tom_at_cdproc.com>
Date: Mon, 6 Nov 2000 12:32:00 -0600
Message-Id: <10672.121230@fatcity.com>

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_at_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 <ORACLE-L_at_fatcity.com>=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_at_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_at_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_at_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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: INITTRANS parameter settings</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Quite right.&nbsp; I intended to mention parallel =

but got=20
distracted then forgot.</DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A href=3D"mailto:alex_hillman_at_physia.com" = title=3Dalex_hillman_at_physia.com>Alex=20
 Hillman</A> </DIV>
 <DIV style=3D"FONT: 10pt arial">To: <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
 title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Monday, November 06, 2000 = 12:15=20
 PM</DIV>
 <DIV style=3D"FONT: 10pt arial">Subject: RE: INITTRANS = parameter=20
 settings</DIV>
 <DIV> </DIV>
 I think that even one session can use parallel DML = and in this=20
 case increase for INITRANS and multiple freelists should =

help.</FONT></P>
  <P><FONT size=3D2>Alex Hillman</FONT> </P>
  <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =

size=3D2>From: Tom=20
 Pall [<A =
href=3D"mailto:tom_at_cdproc.com">mailto:tom_at_cdproc.com</A>]=20 Sent: Monday, November 06, 2000 11:46 AM = <FONT=20
 size=3D2>To: Multiple recipients of list ORACLE-L <FONT=20 size=3D2>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 <FONT=20 size=3D2>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.  = <FONT=20
 size=3D2>Having initrans/maxtrans higher than needed for concurrency = wastes=20
 block space. 
 ----- Original Message ----- To:=20
 Multiple recipients of list ORACLE-L = <ORACLE-L_at_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 = <FONT=20
 size=3D2>> Sonia P. > >=20

  __________________________________________________</FONT> <BR><FONT=20

size=3D2>> Do You Yahoo!? > Thousands = of=20
 Stores.  Millions of Products.  All in one Place. = <FONT=20
 size=3D2>> <A href=3D"http://shopping.yahoo.com/"=20 target=3D_blank>http://shopping.yahoo.com/</A> > --=20
 > Please see the official ORACLE-L FAQ: = <A=20
 href=3D"http://www.orafaq.com" =
target=3D_blank>http://www.orafaq.com</A>=20 > -- > Author: = sonia=20
 pajerowski >   INET:=20 spajerowski_at_yahoo.com > <FONT=20 size=3D2>> Fat City Network Services    -- (858)=20 538-5051  FAX: (858) 538-5051 > San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists >=20 =

--------------------------------------------------------------------</FON=

T>=20
 > To REMOVE yourself from this mailing list, = send an=20
 E-Mail message > to: ListGuru_at_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: <A href=3D"http://www.orafaq.com"=20 target=3D_blank>http://www.orafaq.com</A> -- =

Author: Tom Pall   INET:=20
 tom_at_cdproc.com 
 Fat City Network Services    -- (858) =

538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>----------------------------------------------------------------=

----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_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 Received on Mon Nov 06 2000 - 12:32:00 CST