SQL to monitor Long running operations


select round(sl.sofar/sl.totalwork*100,2) percent_completed, sl.*, sq.sql_text from v$session_longops sl,v$sql sq where sl.sofar <> sl.totalwork and sl.sql_id=sq.sql_id order by sl.target, sl.sid;