Re: STATSPACK

It is your code ... U need to Check if Your Devs are just Parsing and Not executing Queries...

Cheers
Ganesh

On Fri, 01 Oct 2004 11:04:59 -0400, Seema Singh <oracledbam_at_hotmail.com> wrote:
> Hi,
>
> Statspack report shows.
> Instance Efficiency Percentages (Target 100%)
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Buffer Nowait %: 100.00 Redo NoWait %: 99.99
> Buffer Hit %: 90.75 In-memory Sort %: 99.95
> Library Hit %: 87.93 Soft Parse %: 70.05
> Execute to Parse %: 1.34 Latch Hit %: 99.99
> Parse CPU to Parse Elapsd %: % Non-Parse CPU:
>
> execute to parse % ratio is too low.How to fix that one?
> thanks
> -Seema
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l