Import datapump job status

Often time I find myself having to do imports of data and during the import process we used is see import job status using below option.

1. Use the UNIX “ps –ef” command to track the import the command problem.  Good way to make sure that the process hasn’t error our and quite.
2. From the UNIX command prompt, use the “tail –f” option against the import log file.  This will give you updates as the log file records the import process.
3. Set the “status” parameter either on the command line or in the parameter file for the import job.  This will display the status of the job on your standard output. 
4. Use the database view “dba_datapump_jobs” to monitor the job.  This view will tell you a few key items about the job.  The important column in the view is STATUS.  If this column says “executing” then the job is currently running.
5. Lastly, a good way to watch this process is from the “v$session_longops” view.  This view will give you a way to calculate percentage completed.