Re: dbms_stats.gather_schema_stats with the option gather_auto

On Jun 23, 6:12 am, michael.spo..._at_web.de wrote:
> > Again, not without actually generating those statistics.
> > GATHER_SCHEMA_STATS isn't a preprocessor to output which objects might
> > be processed, it is a procedure to actually generate the statistics
> > and report which objects were considered STALE or empty.
>
> David,
>
> any other ideas or possibilites?

Use RMAN to duplicate the db and run it there.

Also check out the "Managing Optimizer Statistics" chapter in the performance manual. You can save and restore statistics. If you are worried about it, you can lock statistics. Also note the older statistics are saved automatically by default, for a while.

jg

--
@home.com is bogus.
Biggest loser ever finds new career as motivational speaker:
http://www.catalyst.burtongroup.com/NA08/nickleeson.pdf