Thanks! G> This is a known bug in Oracle which ought to be fixed in 9i. G> Gudmundur G> ----- Original Message ----- G> From: "Robert Eskridge" <bryny@xxxxxxxxxxx> G> To: <oracle-l@xxxxxxxxxxxxx> G> Sent: Monday, June 21, 2004 11:40 PM G> Subject: /*+ ULE*/ ??? >> Oracle 8.1.7, Solaris 9. >> >> 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 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------