DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: buffer cache hit ratio

Threaded View

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    buffer cache hit ratio

    Hi all,

    I ran the below query on my database and I got:
    Code:
    select a.value + b.value "logical_reads", 
    c.value "phys_reads",
    round(100 * ((a.value+b.value)-c.value) / 
    (a.value+b.value)) 
    "BUFFER HIT RATIO" 
    from v$sysstat a, v$sysstat b, v$sysstat c
    where 
    a.statistic# = 38 
    and 
    b.statistic# = 39 
    and 
    c.statistic# = 40;
    WITH dB_CACHE_SIZE =712M IS IT STILL TOO SMALL???
    logical_reads phys_reads BUFFER HIT RATIO
    8982109 39133012 -336




    just want to confirm with you guys
    Last edited by learning_bee; 01-17-2005 at 04:31 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width