DBMS_STATS.IMPORT_SCHEMA_STATS is running slow in 19c
(Doc ID 2929670.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Import schema statistics is taking long time on 19c database than 11g when the schema has lots of partitioned tables.
Example: exec dbms_stats.import_schema_stats('OWNER','STAT_TABLE_NAME');
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
Symptoms |
Cause |
Solution |
References |