Re: HOWTO gather statistics on cloned test database to import into production?

"John Claxton" <claxton_at_networkessentials.com> wrote in message news:2e257b19.0110290903.2785cb0b_at_posting.google.com...
> Any ideas?
> Here's the concept: To reduce the downtime on a production system
> during an upgrade, generate statistics on a cloned database before
> hand, and then upload/import/whatever into the production database at
> the appropriate point during the upgrade.
> Any help appreciated.
> jc

And of course no version again, while the answer is version specific.

In any version you can have export generate appropiate analyze estimate or analyze compute statements
In 8.1.6 and beyond you can use the dbms_stats package to gather statistics in your own tables. Afterwards you can 'import' them into the datadictionary tables.

Please read up the Oracle supplied packages manual on dbms_stats.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Mon Oct 29 2001 - 11:41:15 CST