A developer brought me a pl/sql procudure that had a select /*+RULE*/
hint in it. It was performing poorly (to the point of blowing out temp
space with an ORA-01652 (See ORA-01652.ora-code.com) error. When we looked at sql running in
v$sqltext, we saw that the hint had changed to /*+ ULE*/.
Cutting the select out and and running it in either TOAD or SQL*Plus
and performed well. But in the procedure we messed around with it
and kept getting the ULE (and the resulting full table scans) until we
looked at the docs and put spaces everyhere ( /*+ RULE */ ). Is this
well known behavior? I 'm wondering if I should scan all our
procedures for this syntax....
-rje
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
