查询正在做的排序操作

 

select a.tablespace,
       a.SEGFILE#,
       a.segblk#,
       a.blocks,
       b.sid,
       b.serial#,
       b.username,
       b.osuser,
       b.status
  from v$sort_usage a, v$session b
 where a.session_addr = b.saddr

转载于:https://www.cnblogs.com/czjie/archive/2011/11/22/2259583.html