Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

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 !