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
H on our 9204 instance this package is compiled with the order by ... our
compatible is set to 9.2.0.4
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
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