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 [EMAIL PROTECTED] ----- 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).