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 -> very low hit ratio

very low hit ratio

From: JW <jwu_at_nctr.fda.gov>
Date: 24 Mar 2004 13:10:30 -0800
Message-ID: <f4d9400.0403241310.150b1fb4@posting.google.com> 





we have a data warehouse type of database and I noticed that buffer
cache hit ratio is very low: db block gets 37,173,962; consistent gets
349,994,093; physical reads 888,341,652. Is this normal in a
datawarehouse environment? Thanks.
Received on Wed Mar 24 2004 - 15:10:30 CST












Original text of this message













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