Set Feedback Off
Set Echo Off
Set Heading Off
Set Term Off

Column Instance New_Value _Instance NoPrint
SELECT 'OSR_' || name Instance FROM v$database;

spool &&_instance..txt

-- Memory Sort Rate

select round((sum(decode(name, 'sorts (memory)', value, 0))
/ (sum(decode(name, 'sorts (memory)', value, 0))
+ sum(decode(name, 'sorts (disk)', value, 0))))
* 100,2) "Sort in Memory %"
from v$sysstat;

spool off;
Set Feedback On
Set Echo On
Set Heading On
Set Term On

exit;