REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_db_sort_ratio.sql
REM
REM <SQLDIR_GRP>STATS</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports sort ratios
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_db_sort_ratio.sql
REM 
REM Example:
REM	s_db_sort_ratio.sql
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM

prompt
prompt Ratio Should Be < 5%
prompt If Ratio > 5% then increase SORT_AREA_SIZE
prompt



select  disk.value  "Disk"
,       mem.value   "Mem"
,       (disk.value/mem.value)*100 "Ratio"
from    v$sysstat   disk
,       v$sysstat   mem
where   mem.name = 'sorts (memory)'
and     disk.name = 'sorts (disk)'
/


col name format a25
col value format 9999999999999

select * from v$sysstat
where name like '%sort%'
/