DBMS_STATS GATHER STATISTICS on table with BITMAP and BTREE indexes runs forever
Table information: non-partition table with 25 million rows
Indexes - 1. PK (composite index)- b*tree index 2.8gb in size
2. composite index(two column) - b*tree index 1gb size
3. bitmap index on a single column - 17mb in size
Oracle DB: 10.2.0.4(5 node RAC) on Linux 5.5
I am trying to tune a query and realized that for one of the big table the stats were not gathered since last September 2010. I tried to gathered stats as below but it did not complete after two days.
EXEC dbms_stats.gather_table_stats('PROD','IRC_DISPENS', degree =>4, cascade=>TRUE);
now i am running old analyze table ....compute statistics but it has been running for past 45 minutes.
2. composite index(two column) - b*tree index 1gb size
3. bitmap index on a single column - 17mb in size
Oracle DB: 10.2.0.4(5 node RAC) on Linux 5.5
I am trying to tune a query and realized that for one of the big table the stats were not gathered since last September 2010. I tried to gathered stats as below but it did not complete after two days.
EXEC dbms_stats.gather_table_stats('PROD','IRC_DISPENS', degree =>4, cascade=>TRUE);
now i am running old analyze table ....compute statistics but it has been running for past 45 minutes.
0