Home » Other » Training & Certification » Sort activity (Oracle 9.2.0.8)
Sort activity [message #350841] Fri, 26 September 2008 12:41 Go to previous message
shrinika
Messages: 298
Registered: April 2008
Senior Member
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)'
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Difference between Oracle 9i and Oracle 10g OCA developer's exam
Next Topic: Oracle Service Contracts Billing Schedule Tables
Goto Forum:
  


Current Time: Sun Dec 15 19:42:55 CST 2019