Oracle长时间操作会话(六秒以上)查询

SELECT T.USERNAME,
T.OPNAME,
T.TARGET,
T.SOFAR,
T.TOTALWORK,
T.TIME_REMAINING,
T.ELAPSED_SECONDS,
T.MESSAGE
FROM SYS.V_$SESSION_LONGOPS T
WHERE T.SOFAR <> T.TOTALWORK