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
Applies to:
Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and later
IBM AIX on POWER Systems (64-bit)
Symptoms
- 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,
Changes
Database is upgraded from 12c to 19c
Cause
| |
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.