Re: High sorts(disk) Value

Anurag

Look at the percentage of sorts(disk) to sorts(memory). It's so low it's not worth worrying about. Yes, increasing the SORT_AREA_SIZE may reduce the number of sorts going to disk, but remember SORT_AREA_SIZE is allocated on a per process basis, so you may end up using up the memory on the machine and causing worse performance due to paging.

My advice is to not bother changing it.

Pete

Anurag Minocha wrote:

> 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

--
Regards

Pete

Received on Fri Jul 23 1999 - 11:22:12 CDT