fire off multiple dbms_stats.gather_schema 2004-07-08 - By David
To my understanding dbms_stats with a parallel degree set will analyze a
given table in parallel using PQ slaves. I do use parallel, but I want to
run concurrent schema dbms_stats gather with parallel also instead of
having gather_schema run through the the schemas serially.
I would like to use gather auto or gather stale, but we can 't enable table
monitoring just yet and I think table monitoring is required for gather
stale and gather auto. Right now I pan on using Gather once a month and
then gather empty weekly, with a granularity of partition.
Cheers
--
..
David
>
> > David
> > Dumb question. I always understood that: "Whenever possible,
> > dbms_stats
> > routines will run via parallel query ". Is there a reason this doesn 't
> > work
> > for you?
> > Another idea. Instead of making dbms_stats run faster, consider
> > whether
> > you are spending too many resources analyzing. dbms_stats can use the
> > GATHER
> > STALE option. I think Wolfgang Breitling has stated that once his
> > queries
> > are operating satisfactorily he doesn 't gather statistics any more.
> >
> > Dennis Williams
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
