My Oracle Support Banner

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

Last updated on NOVEMBER 02, 2018

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.

Purpose

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

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