DBA_DATAPUMP_JOBS:
This view will show the active Data Pump jobs, their state, degree of parallelism, and the number of sessions attached.
DBA_DATAPUMP_SESSIONS:
This view gives the SADDR that assist in determining why a Data Pump session may be having problems. Join to the V$SESSION view for further information.
V$SESSION_LONGOPS:
This view helps determine how well a Data Pump export is doing. Basically gives you a progress indicator through the MESSAGE column.
No comments:
Post a Comment