DBMS_STATS - Global Statistics

From: Donna <dhoffman0917_at_yahoo.com>
Date: 18 Mar 2002 15:37:18 -0800
Message-ID: <79808a91.0203181537.3898e0ad@posting.google.com>

Has anyone experienced really slow completion time when trying to execute DBMS_STATS for GLOBAL STATISTICS? Are there ways to speed up the process?

Platform:
Oracle 8.1.7.2
Solaris 8 - UNIX / 4 CPU machine
Implementation - Star Schema Datamart with Partitioned Fact Tables

I have a table with 50 partitions each of approx. 7 million rows. Each partition has partition level statistics on them and I am trying to generate GLOBAL STATISTICS. So far it is taking days to complete. I got as far as 8 partitions analyzed in a 48 hour period. Here is my script: (I have a line for each partition. Any ideas?)

DBMS_STATS.GATHER_TABLE_STATS ('CPG','SORT_ANALOG','SA_P45',50,false, 'FOR ALL COLUMNS SIZE 1',4,'DEFAULT',true);

Thanks
Donna Received on Mon Mar 18 2002 - 17:37:18 CST