Personal tools
You are here: Home Oracle How To's How to check the Sort HIT Ratio (Memory vs. Disk)
Navigation
Log in


Forgot your password?
 
Document Actions

How to check the Sort HIT Ratio (Memory vs. Disk)

How to check the Sort HIT Ratio (Memory vs. Disk)


SELECT 100*(a.value-b.value)/(a.value) AS "Sort Ratio" FROM v$sysstat a, v$sysstat b WHERE a.name = 'sorts (memory)' AND b.name ='sorts (disk)'

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls