/*+ ULE*/ ??? 2004-06-21 - By Robert Eskridge
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@(protected) >
G > To: <oracle-l@(protected) >
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 (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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
