dbms_stats.gather_schema_

From: Paula Winkler <pw41972@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Sun, 14 Mar 2004 15:36:55 -0800 (PST)

Hi listers,
 
I am trying to improve our statistics gathering process which takes several 
hours.  Does the degree parameter work in the below 
dbms_stats.gather_schema_stats call in an Oracle 8.1.7.4 database on HPUX 11i?  
Oracle seems to ignore the degree specification and run serially.
  
   dbms_stats.gather_schema_stats ( 
      NULL,   --ownname VARCHAR2, 
      20,   --estimate_percent NUMBER DEFAULT NULL, 
      FALSE,   --block_sample BOOLEAN DEFAULT FALSE, 
      'FOR ALL COLUMNS SIZE 25',   --method_opt VARCHAR2 DEFAULT 'FOR ALL 
COLUMNS SIZE 1', 
      4,   --degree NUMBER DEFAULT NULL, 
      'ALL',   --granularity VARCHAR2 DEFAULT 'DEFAULT', 
      TRUE   --cascade BOOLEAN DEFAULT FALSE 
     ); 

Thank you in advance for your help!
 
- Paula W.

Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam

Follow-Ups:
- Re: dbms_stats.gather_schema_
  - From: Paula Winkler
- Re: dbms_stats.gather_schema_
  - From: Darrell Landrum

References:
- RE: question about dbms_syste.set_sql_trace_in_session
  - From: Cary Millsap

dbms_stats.gather_schema_

Other related posts: