From: William Robertson on
On Jun 23, 1:17 pm, michael.spo...(a)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?
From: fitzjarrell on
On Jun 24, 2:28 am, William Robertson <williamr2...(a)googlemail.com>
wrote:
> On Jun 23, 1:17 pm, michael.spo...(a)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?

Apparently it does, thank you William.


David Fitzjarrell