Thanks. Gee, the Oracle sales folks keep telling our Lead Architect that RAC requires zero code changes...guess this was not true for Statspack.
:) -----Original Message----- Sent: Monday, January 26, 2004 12:14 PM To: Multiple recipients of list ORACLE-L Ethan: You can remove the order by if you are not using RAC. Basically it is to avoid two identical SQLs inserted at the SAME time in RAC setup. If you are using RAC just add another column in the order by condition. (st1.hash_value,ss.text_subset,st1.piece) I don't have the bug # handy. But I was told this is fixed in 10g ;) KG ===== Have a nice day !! ------------------------------------------------------------ Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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: Post, Ethan 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).
