Sorry about leaving off the db version (8.1.7). Thanks for you tip on
dbms_stats. That pointed me to a document on metalink [117203.1] for
those interested.
jc
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ttr67tpvussfbd_at_corp.supernews.com>...
> "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 - 16:42:03 CST
