dbms_stats.gather_schema_

From: Paula Winkler <pw41972_at_yahoo.com>
Date: Sun, 14 Mar 2004 15:36:55 -0800 (PST)
Message-ID: <20040314233655.69349.qmail@web61107.mail.yahoo.com>

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

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org 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
-----------------------------------------------------------------

Received on Sun Mar 14 2004 - 17:33:21 CST