From oracle-l-bounce@freelists.org Thu Mar 18 15:59:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2ILxPR32508 for ; Thu, 18 Mar 2004 15:59:25 -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 i2ILxPo32502 for ; Thu, 18 Mar 2004 15:59:25 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 54BB8395F3F; Thu, 18 Mar 2004 16:41:38 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 18 Mar 2004 16:40:07 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from web61110.mail.yahoo.com (web61110.mail.yahoo.com [216.155.196.112]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 8DB86395DAD for ; Thu, 18 Mar 2004 16:34:52 -0500 (EST) Message-ID: <20040318213430.9402.qmail@web61110.mail.yahoo.com> Received: from [68.163.64.125] by web61110.mail.yahoo.com via HTTP; Thu, 18 Mar 2004 13:34:30 PST Date: Thu, 18 Mar 2004 13:34:30 -0800 (PST) From: Paula Winkler Subject: RE: Stored Outlines and Optimizer Mode To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1542882187-1079645670=:7933" X-archive-position: 1195 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: pw41972@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --0-1542882187-1079645670=:7933 Content-Type: text/plain; charset=us-ascii Thank you Niall and Lex for your responses. We have a 3rd-party Oracle8i system running under the RULE-based optimizer. We have identified a handful of poor performing SQLs. We can't change the generated SQLs therefore we are looking into using stored outlines to store the access plans for those exceptional SQLs. Our thought is CBO would kick in for the SQLs with the stored outlines and RBO would kick in for the other acceptable SQLs. Does this sound like it will work? - Paula W. Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam --0-1542882187-1079645670=:7933 Content-Type: text/html; charset=us-ascii
Thank you Niall and Lex for your responses.
 
We have a 3rd-party Oracle8i system running under the RULE-based optimizer.  We have identified a handful of poor performing SQLs.  We can't change the generated SQLs therefore we are looking into using stored outlines to store the access plans for those exceptional SQLs.  Our thought is CBO would kick in for the SQLs with the stored outlines and RBO would kick in for the other acceptable SQLs.  Does this sound like it will work?
 
- Paula W.
 
 

Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam --0-1542882187-1079645670=:7933-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------