Check Query time estimation in oracle database

 Check Query time estimation in oracle database

SELECT target_desc, ROUND( ( sofar / totalwork ) * 100, 2 ) percent_complete, ROUND( time_remaining / 60, 2 ) minutes_remaining FROM   v$session_longops WHERE  sid = <session_id>  AND    serial# = <session_serial#>;