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?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 30 2006 - 11:00:25 CST
