Thanks Brad, Thanks Steve, The problem fixed after our DBA drop and rebuild the primary key. It is so great to have people like you on this list.
Thanks again, ---------------------------------------------- Original Message Date: Tue, 13 Jan 2004 08:59:24 -0800 >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). > _____________________________________________ 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).