Oracle Session Level Hit Ratio

Do you need to know what is the hit ratio by each user? If yes, the SQL command as below will help you to identify it: -

Check Oracle Session Hit Ratio

SQL> SELECT Username,
OSUSER,
Consistent_Gets,
Block_Gets,
Physical_Reads,
100*( Consistent_Gets + Block_Gets - Physical_Reads)/
( Consistent_Gets + Block_Gets ) "Hit Ratio %"
FROM V$SESSION,V$SESS_IO
WHERE V$SESSION.SID = V$SESS_IO.SID
AND ( Consistent_Gets + Block_Gets )>0
AND username IS NOT NULL
ORDER BY Username,"Hit Ratio %";

Leave a Comment

Recent Posts

Recent Comments

shubhod salian: Hi Indu, You need to execute adadmin on node B , simply because your forms server resides on this...
hari: May I know what is the referred meta link for the permanent solution.
guru: Hi Indu, you just need to run once if your multi node apps environment is running on shared APPL_TOP...
indu: hi guru, my application is in multi node environment. admin, concurrent, report servers are in node A. form and...
Hussain: Thanks Guru for your quick and kind help.

RSS

RSS