Re: INITRANS question

INITRANS reserves block header control "blocks" for each row potentially locked in the block by a transaction. Find out how many rows there are on average in your data blocks and that is the absolute maximum you need for INITRANS for that object. Of course, in reality you would most likely be using a LOT less than that max.

As a rule of thumb, I set it to the number of CPUs in the system. The logic: well, there can only be number of CPU threads actually concurrently updating the same block at the same time. So that is my setting. Works fine from where I'm standing. Most likely even that is excessive. Particularly if you use a 64 CPU system. I wouldn't go much higher than 6.

Of course YMMV, IMHO, you-may-be-running-V6, etc etc.

Cheers
Nuno Souto
nsouto_at_optushome.com.au

• Original Message -----
  > I have few tables with a lot of transaction by many users, I change
  the
  > Initrans from 1 to 5 and for some to 25, My question is what's the
  best way
  > to findout which value is the optimum value for INITRANS for each
  table?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nuno Souto
  INET: nsouto_at_optushome.com.au

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