Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

dbms_stats.gather_schema_stats with the option gather_auto

12 views
Skip to first unread message

michael...@web.de

unread,
Jun 23, 2008, 8:17:06 AM6/23/08
to
Hi,

is there a possibility to use the dbms_stats package on schema level
to just see which tables would be affected by the gather_auto option?

I want first see which tables would be analyzed depending on the
output I want to start the dbms_stats package for this schema, or
maybe just for some less tables of this output.

Regards

Michael

ora...@msn.com

unread,
Jun 23, 2008, 9:01:52 AM6/23/08
to
Comments embedded.

On Jun 23, 7:17 am, michael.spo...@web.de wrote:
> Hi,
>
> is there a possibility to use the dbms_stats package on schema level
> to just see which tables would be affected by the gather_auto option?
>

Not without actually generating those statistics.

> I want first see which tables would be analyzed depending on the
> output I want to start the dbms_stats package for this schema, or
> maybe just for some less tables of this output.

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.

>
> Regards
>
> Michael


David Fitzjarrell

michael...@web.de

unread,
Jun 23, 2008, 9:12:13 AM6/23/08
to
> 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?

ora...@msn.com

unread,
Jun 23, 2008, 9:35:46 AM6/23/08
to

You might try querying the DBA_TAB_MODIFICATIONS view, which lists the
tables which have been modified since the last statistics run.


David Fitzjarrell

joel garry

unread,
Jun 23, 2008, 1:14:39 PM6/23/08
to

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

William Robertson

unread,
Jun 24, 2008, 3:28:38 AM6/24/08
to

Doesn't options => 'LIST AUTO' do it?

ora...@msn.com

unread,
Jun 24, 2008, 10:38:30 AM6/24/08
to
On Jun 24, 2:28 am, William Robertson <williamr2...@googlemail.com>
wrote:

Apparently it does, thank you William.


David Fitzjarrell

0 new messages