I have been running this query all the time to monitor sorting in memory in relation to disk but today it's not working. Can anyone tell me where I'm missing something. I now it might be somethig trivial, but I still can't get it.



SQL> select a.value "Disk Sorts", b.value "Memory Sorts",
round(100 *b.value)/decode((a.value+b.value),
0,1,(a.value+b.value)),2) "Pct Memory Sorts"
from v$sysstat a, v$sysstat b
where a.name = 'sorts (disk)'
and b.name = 'sorts (memory)'
0,1,(a.value+b.value)),2) "Pct Memory Sorts"
*
ERROR at line 3:
ORA-00923: FROM keyword not found where expected