Moneycontrol Brokerage Recos

Tuesday, September 20, 2011

What are the views available to see the information about export.



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