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 ----- From: sonia pajerowski <spajerowski_at_yahoo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, November 06, 2000 8:50 AM Subject: INITTRANS parameter settings

> 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).
Received on Mon Nov 06 2000 - 10:42:47 CST