Thanks Davey.

I expected like, when oracle is able to predict the TIME_REMAINING for the executions in v$session_longops then it should have some predictions about the whole query based the stats available and the execution plan it generated.

Thanks,