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