Hello all
i've a query running since last 5 hours, which should have finished by 4 hours. Upon checking v$session_lops, I found that time_remamining is ever increasing. I had to kill the session and now I'll have to run the proc again. Could anybody please suggest/advice what could have gone wrong there or if there is anything, I can do to prevent in the next run? Any help is appreciated.

Thanks,
gtcol