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).