Sorting (Part 2)

The SQL below shows how many sorts have been done in memory and how many have had to go out to disk since instance startup:

SQL> col name format a20

SQL> l

  1  select name, value

  2  from v$sysstat

  3* where name in ('sorts (memory)', 'sorts (disk)')

SQL> /

NAME                      VALUE

-------------------- ----------

sorts (memory)          1758574

sorts (disk)                  0

SQL>