Oracle 中查看比较大的排序进程

sys@DEX> select * from v$statname where name like '%sort%' ;  
  
STATISTIC# NAME                                          CLASS    STAT_ID  
---------- ---------------------------------------- ---------- ----------   
       565 sorts (memory)                                   64 2091983730  
       566 sorts (disk)                                     64 2533123502  
       567 sorts (rows)                                     64 3757672740 
这里使用rows作为metric 
sys@DEX> select s.sid "session id", st.value "sort(rows)" ,p.spid "process number"  
  2    from v$session s , v$sesstat st , v$process p  
  3   where s.sid=st.sid  
  4     and s.paddr=p.addr  
  5     and st.statistic#=567  
  6     and s.username='DEX'  
  7     order by st.value desc ;  
  
  
session id sort(rows) process number  
---------- ---------- ------------------------------------------------------------------------   
        30    1818678 2223  
       155     909404 5573 

服务器租用/服务器托管中国五强！虚拟主机域名注册顶级提供商！15年品质保障！--亿恩科技[ENKJ.COM]