Secret maximum for INITRANS?

From: Robert Eskridge <bryny_at_dfweahs.net>
Date: Mon, 04 Mar 2002 16:08:26 -0800
Message-ID: <F001.0041EE9F.20020304160826@fatcity.com>

I'm still messing with my enqueue waits on an insert. I'm now able to recreate it on a test database by throwing enough simultaneous inserts at my table. I was going to make sure which of the tables/indexes was actually causing the waits by individually raising the INITRANS above what they would naturally expand to, and see how the waiting sessions responded.

I was hitting it with 50 simultaneous inserts and usually had 10 sessions go into an enqueue wait until the 40 sessions committed or rolled back. So I was going though the indexes and then tables raising the INITRANS to 50 to see which one(s) made a difference. None of them made a difference.

So I dumped blocks that had been populated only during this exercise. Invariably, there were 0x29 Itl slots. Is there something out there that would limit the Itl entries to 41 even when MAXTRANS=255? Is there some secret bound based on block size? Ours is 2k (which I figure is part of the problem).

Other vital stats: 8.0.5 on Solaris 2.7.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Robert Eskridge
  INET: bryny_at_dfweahs.net

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 Mar 04 2002 - 18:08:26 CST