Sql Query to locate the long running operations in database

select sid
      , username
      , opname
      ,target
      , decode(totalwork,0,0,null,0,sofar*100/totalwork) progress
      , totalwork
      , units
      , start_time
      , elapsed_seconds
      ,sql_id
from v$session_longops
order by sid, start_time