Export, Import or Deletion of Table Statistics into statistics table is slow with DBMS_STATS in 19.16
(Doc ID 2949078.1)
Last updated on MAY 16, 2023
Oracle Database - Enterprise Edition - Version 220.127.116.11.0 and later
IBM AIX on POWER Systems (64-bit)
- Copy or move table statistics(Export, Import or Delete) from one database to another is slow.
- High IO waits are observed with log file sync.
- Multiple expression statistics queries are executed like,
Database is upgraded from 12c to 19c
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.