oracle查看最大进程,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

这里使用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.statisti c#=567

6     and s.username=’DEX’

7     order by st.value desc ;

session id sort(rows) process number

———- ———- ————————————————————————

30    1818678 2223

155     909404 5573

摘自 DexterR的专栏