Oracle 11g enhanced the collection of incremental statistics, such that partition level statistics could be used to accurately calculate global statistics, described here . In 11g, a partition exchange marks the statistics as stale on the new segment, even if they were up to date before the operation. This means the statistics on the partition must be gathered again before they are considered valid and used to update the global statistics. Oracle 12c now supports the use of statistics for a segment used in a partition exchange. Provided the original segment has valid statistics, they will be used to amend the global statistics, removing the need to regather the statistics on the new partition once the exchange is complete.

The DBMS_STATS.GATHER_SYSTEM_STATS procedure includes a new of . This includes additional tests specific for Exadata systems. According to the documentation, "the multi-block read count and IO throughput statistics are set along with the CPU speed." This was present in 11gR2, but it was not documented, so it is now documented as a new feature in the database documentation. For more information see: Hope this helps. Regards Tim...