dbms_stats.gather_table_stats... slow performance
ORACLE10g - 10.2.0.4Linux 5
Table = Daily partitions(total 85 parts). Depending up day of the week, we load 800k to 1.6 million rows daily
NOTE: Data and number of rows has not changed.
Question: How would i find out why is it taking so long to gather stats?
I tried gathering stats with CASCADE => false, but that did not help.
The following statement that used to take 10 minutes 3-4 weeks ago, now taking 45 - 60 minutes.
exec DBMS_STATS.GATHER_TABLE_STATS('PROD','CLAIM_TRANSACTION', partname => 'P20130404', estimate_percent => 10 ,degree => 4,CASCADE => TRUE);
Data Load Steps:
1. create partition for today
2. insert append data from a large table into this CLAIM_TRANSACTION table
Table = Daily partitions(total 85 parts). Depending up day of the week, we load 800k to 1.6 million rows daily
NOTE: Data and number of rows has not changed.
Question: How would i find out why is it taking so long to gather stats?
I tried gathering stats with CASCADE => false, but that did not help.
The following statement that used to take 10 minutes 3-4 weeks ago, now taking 45 - 60 minutes.
exec DBMS_STATS.GATHER_TABLE_STATS('PROD','CLAIM_TRANSACTION', partname => 'P20130404', estimate_percent => 10 ,degree => 4,CASCADE => TRUE);
Data Load Steps:
1. create partition for today
2. insert append data from a large table into this CLAIM_TRANSACTION table
0