OraQA

You can use the following SQL statement to determine the amount of sorting in memory and on disk:

Select name, value from v$sysstat
where name in ('sorts (memory)', 'sorts (disk)');

If a large number of sorts requires I/O to disk, increase the initialisation parameter SORT_AREA_SIZE.

Filed under Administration, SQL. Follow any responses to this entry through this RSS 2.0 feed.