Re: dbms_stats.gather_schema_stats with the option gather_auto
Date: Tue, 24 Jun 2008 07:38:30 -0700 (PDT)
On Jun 24, 2:28 am, William Robertson <williamr2..._at_googlemail.com> wrote:
> 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?
Apparently it does, thank you William.
David Fitzjarrell Received on Tue Jun 24 2008 - 09:38:30 CDT