RE: IOT Issues?

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Fri, 13 Dec 2002 16:34:31 -0800
Message-ID: <F001.00519B72.20021213163431@fatcity.com>

"The first one (seen in 8.1.6 and 8.1.7) was deadlocks caused by simultaneous SELECTs and the addition of a new partition (even though the queries were not querying the partition). Those deadlocks were occurring at the dictionary level - because even if an IOT is physically a single index, logically it's still a table and a PK index. Quite obviously, a SELECT puts a SHARE dictionary lock on both - and so does the ALTER. The snag is that one locks the table first and the index second, while the other does the opposite. Ouch. It may or may not be fixed by now."

They FINALLY fixed it... The fix is in the 8.1.7.3 patchset... The bug also exists in 9.2.0.1 but is fixed in the 9.2.0.2 patchset... Bug number is 1367114 in case you're interested...

Tim
--

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

Author: Johnston, Tim
  INET: TJohnston_at_quallaby.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Fri Dec 13 2002 - 18:34:31 CST