RE: fire off multiple dbms_stats.gather_schema
- From: "David" <thump@xxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 8 Jul 2004 10:08:24 -0700 (PDT)
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
