Home » Other » Training & Certification » Sort activity (Oracle
Sort activity [message #350841] Fri, 26 September 2008 12:41 Go to previous message
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.

       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 Jul 05 01:24:38 CDT 2020