Copy Stats DBMS_STATS.COPY_TABLE_STATS In 12c Is Performing Much Slower Than 11g
Last updated on AUGUST 22, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms