SQL & PL/SQL

Hello,

I just run a query and got an unexpected output from session long ops

Operation   % Complete  Elapsed Remaining   Total   Start Time          Predicted End Time
Table Scan  176.64      849                         01.02.2011 13:34:30 01.02.2011 13:48:39
Table Scan  100         24      0           24      31.01.2011 22:28:06 31.01.2011 22:28:30
...

How can a table scan be more than 100% complete? And it is still running.

SELECT  vsl.opname "Operation"
       ,ROUND(vsl.sofar / vsl.totalwork * 100,2) "% Complete"
       ,vsl.elapsed_seconds "Elapsed (Sec)"
       ,vsl.time_remaining "Remaining (Sec)"
       ,vsl.elapsed_seconds + vsl.time_remaining "Total (Sec)"
       ,TO_CHAR(vsl.start_time,'dd.mm.yyyy hh24:mi:ss') "Start Time"
       ,CASE WHEN vsl.time_remaining > 0 THEN
            TO_CHAR(SYSDATE + (vsl.time_remaining / (60 * 60 * 24)),'dd.mm.yyyy hh24:mi:ss')
        ELSE
            TO_CHAR(vsl.start_time + vsl.elapsed_seconds/86400,'dd.mm.yyyy hh24:mi:ss')
        END
        "Predicted End Time"
FROM    v$session_longops vsl
WHERE   vsl.sid = :SID
ORDER BY vsl.start_time DESC

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Regards
Marcus

Edited by: Marwim on 01.02.2011 14:01 added version