From oracle-l-bounce@freelists.org Mon Jun 21 18:42:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5LNfpI16179 for ; Mon, 21 Jun 2004 18:42:01 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5LNff616170 for ; Mon, 21 Jun 2004 18:41:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DFC2C72C500; Mon, 21 Jun 2004 18:25:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26501-02; Mon, 21 Jun 2004 18:25:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33F0B72C546; Mon, 21 Jun 2004 18:25:26 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 21 Jun 2004 18:24:06 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2241872C3C3 for ; Mon, 21 Jun 2004 18:24:06 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26248-05 for ; Mon, 21 Jun 2004 18:24:06 -0500 (EST) Received: from smtp.mmedia.is (smtp.mmedia.is [217.151.180.18]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8E2D672C3AB for ; Mon, 21 Jun 2004 18:24:05 -0500 (EST) Received: from numenor (adsl176-198.as.mmedia.is [217.151.176.198]) by smtp.mmedia.is (8.12.10/8.12.10/1.0.1) with SMTP id i5LNjNVl000752 for ; Mon, 21 Jun 2004 23:45:23 GMT Message-ID: <001201c457ea$c2738190$0100a8c0@numenor> From: "Gudmundur Josepsson" To: References: <10231432812.20040621184046@dfweahs.net> Subject: Re: /*+ ULE*/ ??? Date: Mon, 21 Jun 2004 23:52:06 -0000 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3262 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gbj@index.is Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org This is a known bug in Oracle which ought to be fixed in 9i. Gudmundur ----- Original Message ----- From: "Robert Eskridge" To: Sent: Monday, June 21, 2004 11:40 PM 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@freelists.org > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org 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 -----------------------------------------------------------------