View large sorting processes in Oracle

1. Sys @ DEX>Select*FromV $ statnameWhere Name Like '% Sort %';
3. STATISTIC #NAMECLASS STAT_ID
4. ----------------------------------------------------------------------
5. 565 sorts (memory) 64 2091983730
6. 566 sorts (disk) 64 2533123502
7. 567 sorts (Rows) 64 3757672740

Here we use rows as metric

1. Sys @ DEX>SelectS. sid"Session id", St. value"Sort (rows )", P. spid"Process number"
2. 2FromV $ session s, v $ sesstat st, v $ process p
3. 3WhereS. sid = st. sid
4. 4AndS. paddr = p. addr
5. 5AndSt. statistic #= 567
6. 6AndS. username ='Dex'
7. 7Order BySt. valueDesc;
10. Session id sort (Rows) Process number
11. --------------------------------------------------------------------------------------------
12. 30 1818678 2223
13. 155 909404 5573