Finding Out The Current SQL Statement A Data Pump Process Is Executing
(Doc ID 1528301.1)
Last updated on MARCH 02, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 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.
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