doc

    Name:   sortlocn.sql

    Author: Mark Gurry


The following script lists how much of the sorting was done in memory
and how much sorting has not fit into the user's SORT_AREA_SIZE and
has been required to be done on disk. 

#

SELECT NAME, VALUE FROM V$SYSSTAT
 WHERE NAME IN ('sorts(memory)', sorts(disk)');