From oracle-l-bounce@freelists.org Fri Oct 21 12:02:25 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9LH2POa021321 for ; Fri, 21 Oct 2005 12:02:25 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9LH2MvX021310 for ; Fri, 21 Oct 2005 12:02:22 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EE8BE20B146; Fri, 21 Oct 2005 12:02:15 -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 23971-02; Fri, 21 Oct 2005 12:02:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66B5320B1AD; Fri, 21 Oct 2005 12:02:15 -0500 (EST) x-mimeole: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D660.E825B10B" Subject: RE: Changing from cost to rule bae optimization on the fly Date: Fri, 21 Oct 2005 10:00:12 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Changing from cost to rule bae optimization on the fly Thread-Index: AcXWYFif0Gowo8lUSaic/srlNLL4BwAAHzmw From: "Kennedy, Jim" To: , "oracle-l" X-OriginalArrivalTime: 21 Oct 2005 17:00:15.0265 (UTC) FILETIME=[E84F6910:01C5D660] X-archive-position: 27345 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jim_kennedy@mentor.com Precedence: normal Reply-To: jim_kennedy@mentor.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.5 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5D660.E825B10B Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable alter session set optimizer_mode=3Drule ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Goodson, Doris Sent: Friday, October 21, 2005 9:56 AM To: oracle-l Subject: Changing from cost to rule bae optimization on the fly Hi List, =20 I am running 9.2.0.2 Oracle on AIX 5.2. My online is acceptable, however COBOL batch is slow. Is there a way that I can switch from cost to rule base optimization for the session running the batch process without having to shut the system down? =20 Thanks, Doris ------_=_NextPart_001_01C5D660.E825B10B Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
alter session set=20 optimizer_mode=3Drule

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Goodson,=20 Doris
Sent: Friday, October 21, 2005 9:56 AM
To:=20 oracle-l
Subject: Changing from cost to rule bae optimization = on the=20 fly

Hi=20 List,

 

I am running 9.2.0.2 = Oracle on AIX=20 5.2.  My online is acceptable, however COBOL batch is slow.  = Is there=20 a way that I can switch from cost to rule base optimization for the = session=20 running the batch process without having to shut the system=20 down?

 

Thanks,

Doris

------_=_NextPart_001_01C5D660.E825B10B-- -- http://www.freelists.org/webpage/oracle-l