From oracle-l-bounce@freelists.org Wed Mar 3 09:59:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23Fxgv08562 for ; Wed, 3 Mar 2004 09:59:42 -0600 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 i23Fxfo08557 for ; Wed, 3 Mar 2004 09:59:42 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E214D394DB3; Wed, 3 Mar 2004 11:00:07 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 10:58:58 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from carbon.btinternet.com (carbon.btinternet.com [194.73.73.92]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 57381394AAF for ; Wed, 3 Mar 2004 10:58:55 -0500 (EST) Received: from [81.133.96.209] (helo=Primary) by carbon.btinternet.com with smtp (Exim 3.22 #23) id 1AyYpZ-0006if-00 for oracle-l@freelists.org; Wed, 03 Mar 2004 16:02:45 +0000 Message-ID: <001f01c40138$f930fc70$6702a8c0@Primary> From: "Jonathan Lewis" To: References: <001701c400c8$57623690$945e8640@CVMLAP02> <20040303142307.GA1649@mladen.wangtrading.com> Subject: Re: RE: query slow in 9i, but not slow in 8i Date: Wed, 3 Mar 2004 16:02:47 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 173 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l That's nothing - I built one query that took over 4 hours to parse. Mind you, it was 255 tables, and rule based. (CBO parsed it in less than a second) Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html March 2004 Hotsos Symposium - The Burden of Proof Dynamic Sampling - an investigation March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial April 2004 Iceland June 2004 UK - Optimising Oracle Seminar ----- Original Message ----- From: "Mladen Gogala" To: Sent: Wednesday, March 03, 2004 2:23 PM Subject: Re: RE: query slow in 9i, but not slow in 8i > Parse time over a minute? Was it a huge query or not? I find it hard to believe. > > ---------------------------------------------------------------- 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 -----------------------------------------------------------------