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: individual query hit ratio

Re: individual query hit ratio

From: Robert <grobert_at_azet.sk>
Date: Fri, 28 Nov 2003 14:17:47 +0100
Message-ID: <bq7i0u$sjk$1@news.telecom.sk> 





Thanks a lot ...



we have SAP running on oracle and there are some quite big performance
problem. Even the "global" cache hit ratio is about 92%. I was measuring the
query hit ratio and I found lots of queries (50-80)which shows hit ratio at
about 7-8%. I was unsure if the given query is suitable. I simply had to
start somewhere. Also other performance params like wait events and some
more indicates good performance shape, but thers is "some" problem.



anyway thank you ...
Received on Fri Nov 28 2003 - 07:17:47 CST












Original text of this message













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