Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Monitor progress of data pump network import?

user11967535Oct 7 2009 — edited Oct 13 2009

I'm on Oracle 10.2.0.4 (SunOS) and performing a data pump network import of a list of tables under a schema.

I see the following views are available for monitoring data pump jobs:

DBA_DATAPUMP_JOBS - a list and state of data pump jobs currently running
DBA_DATAPUMP_SESSIONS - list of user sessions attached to each data pump job (can be joined to v$session)
DBA_RESUMABLE - view the running import job and its status
V$SESSION_LONGOPS - can see total import size and elapsed time for data pump jobs if they run long enough

What other options are available for monitoring the progress of network imports?
Also, is there a way to see which table is currently being processed during a network import of multiple tables?

This post has been answered by Dean Gagne-Oracle on Oct 7 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2009

Added on Oct 7 2009

#database-key-features, #export-import-sql-loader-external-tables

4 comments

3,946 views