Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statspack Will Not Install Oracle 9.2.0.4

RE: Statspack Will Not Install Oracle 9.2.0.4

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Mon, 26 Jan 2004 13:04:31 -0800
Message-ID: <F001.005DE282.20040126130431@fatcity.com>


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: kaygopal_at_yahoo.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).
--

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

Author: Post, Ethan
  INET: Ethan.Post_at_ps.net
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 Mon Jan 26 2004 - 15:04:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US