How to check expdp progress
select t.username,t.START_TIME,t.LAST_UPDATE_TIME,t.TIME_REMAINING,t.ELAPSED_SECONDS,
t.opname,t.target_desc,t.sofar,t.totalwork,t.message from V$SESSION_LONGOPS t where/* t.USERNAME = 'user_name' and*/ t.TARGET_DESC = 'EXPORT';
Source: http://sivasiva2kdba.blogspot.com/2010/01/how-to-check-expdp-progress.html
No comments:
Post a Comment