查看长时间操作

col opname format a32
col target format a32
col perwork format a12
 set linesize 1200
 select sid
      ,opname
      ,target
      ,sofar
      ,totalwork
      ,trunc(sofar/totalwork*100,2)||'%' as perwork
from v$session_longops where sofar!=totalwork and sid=&sid;