At first stab...I would guess that there is something foobarred with the primary key index.
I would rebuild the primary key and try again. Brad O. -----Original Message----- Sent: Monday, January 12, 2004 4:45 PM To: Multiple recipients of list ORACLE-L It is not an expensive query. It runs really fast without the primary key in production but we dont have this problem in the test instance. ---------------------------------------------- Original Message Date: Mon, 12 Jan 2004 14:04:42 -0800 >Even stranger is, that you expect us to solve your problem without knowing >what exactly the problem is! >Does your query consist of a SQL statement? Does it have an execution plan? > >Very strange, indeed. > >Tanel. > > >> Dear List, >> >> I have a very strange query: >> >> The table, data, indexes, constraints are set up exactly same >> The query was running ok in the test database but paused the production >> system. >> It is also running ok in production if the primary key disabled. >> Any ideas? Any input will be greatly appreciated. >> > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Tanel Poder > 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). > _____________________________________________ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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).
