Hello, I am just trying to write the procedure which will run in the database to capture hit ratio,
library cache hit ratio, sort activity etc.
Here is the query i will be using. But when i google it, i see different queries in different links.
I just want to confirm this is the correct one to find out the memory sort.
SELECT ROUND((100 * b.VALUE) /DECODE ((a.VALUE + b.VALUE),
0,1,(a.VALUE + b.VALUE)),2) "Percent memory sorts"
FROM v$sysstat a,
v$sysstat b
WHERE a.name = 'sorts (disk)'
AND b.name = 'sorts (memory)'
] 
Blog
Search
Help
Members
Register
Login
Home
