|
-
If you format the query a little bit it becomes easier to see:
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)'
...that you are missing a ( after the call to round
- Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|