Well when i query the v$session_longops:
This is the result i get. Why time remaining is 0
where as the script is still running?

Thanks!
SQL> select ELAPSED_SECONDS,TIME_REMAINING from v$session_longops where sid
= 28;

ELAPSED_SECONDS TIME_REMAINING
--------------- --------------
22 0

ELAPSED_SECONDS TIME_REMAINING
--------------- --------------
7 0

Oracle LazyDBA home page