查找大开销的SQL脚本

 select L.sid ssid,
       substr(OPNAME, 1, 15) opname,
       target,
       trunc((sofar / totalwork) * 100) pct,
       to_char(60 * sofar * 8192 /
               (24 * 60 * (last_update_time - start_time)) / 1024 / 1024 / 60,
               '9999.0') Rate,
       elapsed_seconds / 60 es,
       time_remaining / 60 tr,
       PROGRAM,
       MACHINE
  FROM v$session_longops L, V$SESSION S
 where time_remaining > 0
   and L.SID = S.SID
 order by start_time