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

Re: PINHIT Ration for Indexes=0.00

From: Vrajesh Patel <vrajesh_p_at_hotmail.com>
Date: Fri, 23 Jul 1999 15:56:53 GMT
Message-ID: <9h0m3.91$%L2.11264@PM01NEWS>


You can use Shared_pool_size and open_cursors initialization parameter to fixed up this.

Shared_pool_size addresses the problem of high numbers of reloads getting as a result of parse trees with eliminate from the buffer cache. You can allocate additional space by increasing Open_Cursors for per session.

Thanks,

--
Vrajesh Patel

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:37984A92.A9DB7936_at_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 - 10:56:53 CDT

Original text of this message

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