Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Location
    Mumbai, India
    Posts
    26

    Question Unanswered: Increasing Hit Ratio for Buffer Cache

    Hit ratios for the database are
    1. Index Lookup 98.99 %
    2. Library Cache 93.39 %
    3. Data Dictionary 99.85 %
    4. Redo Log 100 %
    5. LRU 100 %
    6. Pin Hit 99.99 %
    7. Buffer cache 28.34 %
    8. Sort Hit Ratio 100 %
    My biggest concern is hit ratio for Buffer cache.
    How to increase it?
    *********************************************
    God Bless You.

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Why would you want to "increase it" ? you see, I have seen buffer caches like this mostly on DSS and DW applications.

    I could care less about the buffer cache hit ratio if I haven't received any complaints from user or anything like that.

Posting Permissions

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