Friday, May 9, 2008

Script to tune sorts

REM: Script to tune sorts
REM:*****************************************
REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE.
REM: Author will not be responsible for any damage that may be cause by this script.
REM:*****************************************


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

--If large number of sorts require I/O to disk,increase the initialisation parameter SORT_AREA_SIZE

No comments:

Post a Comment

Thanks for you valuable comments !