web analytics

Oracle: long running queries

col opname FOR a40 col units FOR a10 SELECT  sid ,opname ,sofar ,totalwork ,units ,elapsed_seconds ,time_remaining FROM v$session_longops WHERE sofar != totalwork;