Tuesday, 19 January 2016

Views to monitor Datapump jobs

Oracle 10g provides two new views, DBA_DATAPUMP_JOBS and DBA_DATAPUMP_SESSIONS that allow the DBA to monitor the progress
of all DataPump operations.

But ofcourse there are other views as well:

SQL> select view_name from dba_views where view_name like '%PUMP%';

VIEW_NAME
DATAPUMP_PATHS
DATAPUMP_PATHMAP
DATAPUMP_TABLE_DATA
DATAPUMP_OBJECT_CONNECT
DATAPUMP_DDL_TRANSFORM_PARAMS
DATAPUMP_REMAP_OBJECTS
V_$DATAPUMP_JOB
V_$DATAPUMP_SESSION
GV_$DATAPUMP_JOB
GV_$DATAPUMP_SESSION
USER_DATAPUMP_JOBS
DBA_DATAPUMP_JOBS
DBA_DATAPUMP_SESSIONS
AQ$KUPC$DATAPUMP_QUETAB_S
AQ$_KUPC$DATAPUMP_QUETAB_F
AQ$KUPC$DATAPUMP_QUETAB
AQ$KUPC$DATAPUMP_QUETAB_R



Happy Learning..!!
Cheers..!!



No comments:

Post a Comment