Re: dbms_stats.gather_schema_stats with the option gather_auto

From: <fitzjarrell_at_cox.net>
Date: Mon, 23 Jun 2008 06:35:46 -0700 (PDT)
Message-ID: <7a34a8f5-1ac5-46c5-b83c-02a68cce7435@a1g2000hsb.googlegroups.com>


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.
>
> David,
>
> 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

Original text of this message