My Oracle Support Banner

Slow Query Performance With EXPDP Executing SELECT on SYS.KU$_PFHTABLE_VIEW (Doc ID 2745217.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 18.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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.
 

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.