The
order by st1.hash_value,ss.text_subset; -- deadlock avoidance
Statement in the following Statspack code causes the package not to compile.
Oracle 9.2.0.4.0 64 bit.
Compatible is set to 9.2.0
If I remove the two ORDER BY's in error the package compiles fine. Could
not find anything on
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
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
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
