Re: dbms_stats.gather_schema_stats with the option gather_auto
Date: Mon, 23 Jun 2008 06:35:46 -0700 (PDT)
On Jun 23, 8: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.
> any other ideas or possibilites?
You might try querying the DBA_TAB_MODIFICATIONS view, which lists the tables which have been modified since the last statistics run.
David Fitzjarrell Received on Mon Jun 23 2008 - 08:35:46 CDT