How to check progress of a long running job
For example:
Let say you are trying to rebuild a table ML_SYSTEM_ITEMS_B with move command
alter table INV.ML_SYSTEM_ITEMS_B move;
This session keep on running and you want to check the status.
select target, opname, totalwork, sofar,units, (sofar/totalwork)*100 PERCENTAGE,elapsed_seconds from v$session_longops where target like '%MTL%SYSTEM%' and totalwork <> sofar;
========================================================================
No comments:
Post a Comment