SELECT 'Sorts in Memory ' "Ratio",
ROUND ( (SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME = 'sorts (memory)')
/ (SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME IN ('sorts (memory)', 'sorts (disk)'))
* 100,
2
)
|| '%' "Percentage"
FROM DUAL;