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 -> PINHIT Ration for Indexes=0.00

PINHIT Ration for Indexes=0.00

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Fri, 23 Jul 1999 16:27:22 +0530
Message-ID: <37984A92.A9DB7936@synergy-infotech.com> 





Hi,



I have a production database oracle8.0.5 on NT 4.
My pinhit ratio for index is 0.00 and for body is 0.79. I get this by
querying the v$librarycache .The number of gets for index was 2490 and
for the body was 586.How do i fix this.



Thanks


anurag



reply at


anurag_at_synergy-infotech.com

Received on Fri Jul 23 1999 - 05:57:22 CDT












Original text of this message













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