Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Use of stored outlines with packages

Re: Use of stored outlines with packages

From: Peter Gram <peter.gram_at_miracleas.dk>
Date: Fri, 18 Apr 2003 13:06:56 -0800
Message-ID: <F001.0058518A.20030418130656@fatcity.com>


Hi Bryan

You do not setup stored outline for the package but for the Sql statments in the package.
Have look in : Oracle8i Designing and Tuning for Performance Release 2, Chapter 10 Using Plan Stability for more information.

Rodrigues, Bryan wrote:

>Hello everyone,
>
>I have a stored package that runs great in the test environment and I want
>to put the stored package into production. I have initially tried it in
>production and found the performance to be 40 times worse than in test. I
>have looked at the data in both test and production and found them
>comparable. Both areas production and test have been analyzed since the
>package was used, but nothing of significant difference was found.
>
>The only thing found different was an execution plan varied from test to
>production (test used an index on the table and production did not).
>
>A decision was made to check out using stored outlines to allow us to use
>the execution plan from test in production, but I have not found any
>instructions on setting up stored outlines for packages. Has anyone setup
>stored outlines for packages?
>
>I am working on HP-UX 11.0 with Oracle 8.1.7.4.
>
>Any help would be appreciated.
>
>Thanks,
>
>Bryan Rodrigues
>DBA
>Elcom, Inc.
>
>

-- 
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856
mailto:peter.gram@MiracleAS.dk - http://MiracleAS.dk




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 18 2003 - 16:06:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US