My Oracle Support Banner

Finding Out The Current SQL Statement A Data Pump Process Is Executing (Doc ID 1528301.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


This script could be used as a first step in diagnosing a possible hung or slow Data Pump process. The script will dump the current sql statement the Data Pump Worker process is executing once every 10 minutes along with the current wait event the process is waiting for.

The script should be executed only during periods of slowness or possible hanging scenarios. Otherwise, it has no value, since the current sql statement will be different each time a snapshot is taken as the process is neither slow or hung.

Troubleshooting Steps

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
Troubleshooting Steps

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