High sorts(disk) Value

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Fri, 23 Jul 1999 16:29:28 +0530
Message-ID: <37984B10.E3B657D@synergy-infotech.com>

Hi,

when i issue the following query i get the folowing result. select name,value from v$sysstat where name like '%sort%'

Tablespace VALUE
--------------- ---------

sorts (memory)      84171
  sorts (disk)          238
sorts (rows)      1385008

The documentation says that sort(disk) should be small as possible. Is my sorts(disk) really small or i have to increase the sort_area_size.

will increasing the sort_area_size improve my performance

Thanks
anurag

reply at
anurag_at_synergy-infotech.com Received on Fri Jul 23 1999 - 05:59:28 CDT