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

Thread: ? when determining buffer cache hit ratios

  1. #1
    Join Date
    Aug 2002
    Location
    Brighton, England
    Posts
    93

    ? when determining buffer cache hit ratios

    Have run these queries to work out the buffer cache hit ratios only to discover that the selected stats far from match and am a little bewildered, can anyone shed some light.
    Apologise for the formatting but originally pasted it to Notepad and it looked spot on...




    SVRMGR> select physical_reads, db_block_gets, consistent_gets from v$buffer_pool_STATISTICS;
    PHYSICAL_R DB_BLOCK_G CONSISTENT
    ---------- ---------- ----------
    447 3394 14797
    1 row selected.


    SVRMGR> select * from v$sysstat where name in ('physical reads', 'db block gets', 'consistent gets');
    STATISTIC# NAME CLASS VALUE
    ---------- ---------------------------------------------------------------- ---------- ----------
    38 db block gets 8 3394
    39 consistent gets 8 32003
    40 physical reads 8 1202
    3 rows selected.
    SVRMGR>




    Gus

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

  3. #3
    Join Date
    Aug 2002
    Location
    Brighton, England
    Posts
    93
    Many thanks ggnanaraj


    Gus

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