Re: Use of stored outlines with packages

Bryan

This note from Metalink could help as well : Note:102311.1, How to Move Stored Outlines for One Application from One Database to Another

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).