V$SESSION_LONGOPS sofar/totalwork *always* = 1 in 10g ?

Hi,
I have a script that's been working for years:
> select round((sofar/totalwork)*100,2) ||'%' pct,
> opname, target,
> round(time_remaining/60, 2) minutes
> from v$session_longops
> where round((sofar/totalwork)*100,2) != '100'
> and sid=&&1

that no more works with 10.2 databases. The following
> select sid,sofar/totalwork from v$session_longops ;
ALWAYS returns 1 for sofar/totalwork, even for queries running for... several hours.

Is there something wrong with this view now ? Thanks. Received on Thu Nov 30 2006 - 02:45:42 CST