AskDba.org Weblog

I was working on a performance issue arising due to missing table stats on a new partition for large Partitioned table.This was a 10.2.0.4 database on IBM AIX 5L. So as to resolve the issue , I used dbms_stats.copy_table_stats to copy the stats to new parition from the previous partition. EXEC DBMS_STATS.COPY_TABLE_STATS (‘owner’, ‘tabname’, ‘SourcePart’, ‘TargetPart’) You can find more details about it in below link http://optimizermagic.blogspot.com/2009/02/maintaining-statistics-on-large.html There is one more link explaining this with example http://dioncho.wordpress.com/2009/02/12/how-to-copy-partition-stats-we-got-easier-way/ Article from Optimizer development group states that the low and high value for the target partition is set from the partition key values. But when I used dbms_stats.copy_table_stats, I found that it is not the case and it actually copies the low and high values from the previous partition. You can use following function to check the high and low … Read entire article »