Slow Query Performance With EXPDP Executing SELECT on SYS.KU$_PFHTABLE_VIEW
(Doc ID 2745217.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
During a Data Pump export, the following query can run very slow:
It was found that the database with this symptom had more than 300000 table partitions.
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