Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PINHIT Ration for Indexes=0.00
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