Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: INITTRANS parameter settings

Re: INITTRANS parameter settings

From: Tom Pall <tom_at_cdproc.com>
Date: Tue, 7 Nov 2000 08:04:25 -0600
Message-Id: <10673.121292@fatcity.com>


I was told that once an ITL was created it could not be reused for row data without destroying and recreating the block.

You say this is not true?
----- Original Message -----
From: K Gopalakrishnan <kaygopal_at_yahoo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, November 06, 2000 11:05 PM Subject: Re: INITTRANS parameter settings

> Tom ,
>
> The space reserved by INITRANS only can not be
> (re)used for rowdata. But the space claimed by
> maxtrans can always be used for data.
>
>
>
> --- Gaja Krishna Vaidyanatha <gajav_at_yahoo.com> wrote:
> > 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
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________________________
> 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: K Gopalakrishnan
> INET: kaygopal_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
Received on Tue Nov 07 2000 - 08:04:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US