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 %";

PREV POST » Oracle Session Wait Info

NEXT POST » Oracle Process Locking

Leave a Comment

Recent Posts

Recent Comments

oracle: How about using DBMS_REDEFINITION? It might produce the same result like alter table shrink space command but...
ashok: If you are going to reuse back the space then there’s no need to re-org. However, check this out. APPEND...
andy: Yes, the shrink command will shrink the size of the table and reduce the high water mark (HWM) of the table. If...
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.

RSS

RSS