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 

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]