Wednesday, March 23, 2011

Sorting (Part 2)

Nero 10 HD

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>

No comments: