Logo Background

Oracle Session Level Hit Ratio

  • By on August 20, 2008 | No Comments

    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 %";
    Previous
    Next
    » Oracle Process Locking
Leave a Comment