Re: Exporting and Importing table statistics

It sounds like you want to ensure that an external database has the same execution plan for a query as the one you are developing and/or testing on.

There's a little more to it than that. You must make sure you have the proper init.ora params set, create outlines, and export the outlines for use in another database.

Take a look at Chapter 10 'Using Plan Stability' in the 'Designing and Tuning for Performance' manual.

Jared

On Thursday 24 May 2001 15:18, bonnergj_at_songs.sce.com wrote:
> Hi all,
> According to the 8i utilities manual I should be able to export a tables'
> statistics
> from one database, then import those statistics into another database.
> I have tried various combinations of export and import scripts but nothing
> seems to
> work. My table has none of the restrictions described in the utilities
> manual that
> would prevent the statistics from being exported and then imported.
> Can this export/import of statistics be done at a single table level or
> does it have
> to be a full database export? If not at the table level can it be done at
> the schema
> level?
>
> Thanks everyone,
> Gary Bonner
> bonnergj_at_songs.sce.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).