Copy Stats DBMS_STATS.COPY_TABLE_STATS In 12c Is Performing Much Slower Than 11g
(Doc ID 2291526.1)
Last updated on AUGUST 09, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
- Copy stats (dbms_stats.copy_stats) in 12c is performing poorly compared to 11g.
- As an example, in 11g a copy stats procedure takes 7hrs in total for several partitioned tables (where in 1 min, 3 subpartition stats are copied), but the procedure on 12c with the same objects and data takes 6 to 7hrs for one partitioned table
- AWR showsh the highest consuming sql to be recursive sql:
A change from 11g to 12c.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!