ソート状況を調べる

SELECT name,value FROM v$sysstat WHERE name LIKE '%sort%';

NAME                                                                 VALUE
---------------------------------------------------------------- ---------
sorts (memory)                                                         139
sorts (disk)                                                             0
sorts (rows)                                                          1187