Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: buffer hit cache ratio

Re: buffer hit cache ratio

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 22 Dec 2003 19:36:45 -0800
Message-ID: <cf90fb89.0312221936.14869401@posting.google.com> 





> Tuning by the BCHR is not done by today's top Oracle professionals. 




Depends on who you consider a "top" professional.



Tom Kyte and Cary Millsap both argue that the BHR is not a panacea,
but is IS useful for detecting when the data buffers are way too
small.



The BHR is VERY similar to the v$db_cache_advice view.
Received on Mon Dec 22 2003 - 21:36:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US