View large sorting processes in 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
 
Here we use rows as 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

From column DexterR