From oracle-l-bounce@freelists.org Wed Mar 3 17:53:38 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23Nrax19256 for ; Wed, 3 Mar 2004 17:53:36 -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 i23NrVo19248 for ; Wed, 3 Mar 2004 17:53:32 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B3BBE39516D; Wed, 3 Mar 2004 18:52:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 18:51:13 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ddbcinc.com (unknown [216.222.6.50]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7192D394EE6 for ; Wed, 3 Mar 2004 18:51:08 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4017B.666CA87E" Subject: RE: copy export plan from one database to another Date: Wed, 3 Mar 2004 16:58:18 -0700 Message-ID: <87E9F113CEF1D211A4C3009027301874195CCF@ddbcinc.ddbc.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: copy export plan from one database to another thread-index: AcQBeYxaQv13LJHtQGiknrR+CVNrmwAAP1lw From: "Justin Cave (DDBC)" To: X-archive-position: 269 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jcave@ddbcinc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C4017B.666CA87E Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable A few options- =20 1) You can use dbms_stats to export & import statistics from dev = or test into production 2) You can use optimizer plan stability/ stored outlines to stabilize = a single execution plan. =20 Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC ________________________________ From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Browett, Darren Sent: Wednesday, March 03, 2004 4:45 PM To: oracle-l@freelists.org Subject: copy export plan from one database to another =20 Hi there,=20 We are in a bit of a panic right now, and I am busily searching the = manuals,=20 But is it possible to copy the explain plan that looks good in your = dev/test database to the production=20 database and force your production database to use that explain plan ??=20 I will figure out what went wrong with the production plan once the = panic is over.=20 Thanks=20 Darren=20 -------------------------------------------------------------------------= ------------------------------------------------- Darren Browett P.Eng This = message was transmitted=20 Data Administrator using = 100% recycled electrons=20 Information and Communication Technology=20 City of Coquitlam=20 P:(604)927 - 3614=20 E:dbrowett@coquitlam.ca=20 -------------------------------------------------------------------------= --------------------------------------------------=20 =20 ------_=_NextPart_001_01C4017B.666CA87E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable copy export plan from one database to another

A few = options-

 

1)       = You can use dbms_stats to export & import statistics = from dev or test into production

2) =A0 You can use optimizer plan stability/ stored outlines to stabilize a single execution plan.

 

Justin Cave

Distributed Database Consulting, = Inc.

http://www.ddbcinc.com/askDDBC

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Browett, Darren
Sent: Wednesday, March = 03, 2004 4:45 PM
To: = oracle-l@freelists.org
Subject: copy export plan = from one database to another

 

Hi there,

We are in a bit of a panic right now, and I am busily searching the = manuals,

But is it possible to copy the explain plan that looks good in your dev/test database to the production
database and force your production database to use that explain plan = ??

I will figure out what went wrong with the production plan once the panic = is over.

Thanks

Darren

----------------------------------------------= -------------------------------------------------------------------------= ---

Darren Browett P.Eng                                            This message was = transmitted
Data Administrator                      =                 =         using 100% recycled electrons
Information and = Communication Technology
City of Coquitlam =
P:(604)927 - 3614 =
E:dbrowett@coquitlam.ca =
----------------------------------------------= -------------------------------------------------------------------------= ----

 

------_=_NextPart_001_01C4017B.666CA87E-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------