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

DA Morgan wrote:
> Spendius wrote:
> > 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.
>
> Are your variables defined as INTEGER or FLOATING POINT?

In both cases OP is showing us "just sql". For example,

select sid,sofar/totalwork from v$session_longops ; ALWAYS returns 1 for sofar/totalwork, even for queries running for... several hours.

What variables? There's no variables shown in either piece of sql that OP is claiming is not working on his system. Received on Thu Nov 30 2006 - 11:06:47 CST