Re: High sorts(disk) Value

Desired value for disk sorts is as close to zero as possible. Try quering mutiple time and observe result. If you get sorts(disk) in high, try increasing sort_area_size. But, make sure that adding additional size does not interfere with the real memory into virtual memoery on disk. If real memory is using virual memory, will impact on your perfomance. You can try combination with SORT_AREA_RETAINED_SIZE parameter with combination with SORT_AREA_SIZE. Thanks,

--
Vrajesh Patel

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:37984B10.E3B657D_at_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 - 10:49:36 CDT