AWS-RDS ORACLE-monitor the jobs
To check the status of Datapump operations, you can view the contents of the import log by using the rdsadmin.rds_file_util.read_text_file procedure.
SELECT * FROM TABLE (rdsadmin.rds_file_util.read_text_file(p_directory => 'DATA_PUMP_DIR',p_filename => 'IMPORT.LOG'));
Also below SQL queries would also be helpful to monitor the progress of Datapump jobs. The status of the job:
select * from dba_datapump_jobs where STATE='EXECUTING';
The percentage of work done, like in:
SELECT b.username, a.sid, b.opname, b.target, round(b.SOFAR*100/b.TOTALWORK,0) || '%' as "%DONE", b.TIME_REMAINING, to_char(b.start_time,'YYYY/MM/DD HH24:MI:SS') start_time FROM v$session_longops b, v$session a WHERE a.sid = b.sid ORDER BY 6;
The percentage of work done and the current status of the Datapump job, like in:
SELECT sl.sid, sl.serial#, sl.sofar, sl.totalwork, dp.owner_name, dp.state, dp.job_mode FROM v$session_longops sl, v$datapump_job dp WHERE sl.opname = dp.job_name AND sl.sofar != sl.totalwork;
The following Query displays the amount of work done so far:
SELECT sl.sid, sl.serial#, sl.sofar, sl.MESSAGE,sl.totalwork, dp.owner_name, dp.state, dp.job_mode FROM v$session_longops sl, v$datapump_job dp WHERE sl.opname = dp.job_name;