Global statistics high/low values when using DBMS_STATS.COPY_TABLE_STATS
There is a well-documented problem relating to DBMS_STATS.COPY_TABLE_STATS between partitions where high/low values of the partitioning key column were just copied verbatim from the source partition. This particular problem has now been patched (see 8318020.8). For background, see Doug Burns’ blog and his excellent paper which covers the whole topic of statistics on partitioned tables.
This post Maintaining statistics on large partitioned tables on the Oracle Optimizer blog details what the dbms_stats.
