Oracle 中查看比较大的排序进程
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
- 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
评论暂时关闭