Re: dbms_stats.gather_schema_stats with the option gather_auto
From: William Robertson <williamr2019_at_googlemail.com>
Date: Tue, 24 Jun 2008 00:28:38 -0700 (PDT)
Message-ID: <0a88d7c6-b77e-4c2b-8788-ad85c7b04c85@w7g2000hsa.googlegroups.com>
Date: Tue, 24 Jun 2008 00:28:38 -0700 (PDT)
Message-ID: <0a88d7c6-b77e-4c2b-8788-ad85c7b04c85@w7g2000hsa.googlegroups.com>
On Jun 23, 1:17 pm, michael.spo..._at_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?
>
> 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
Doesn't options => 'LIST AUTO' do it? Received on Tue Jun 24 2008 - 02:28:38 CDT