Re: STATSPACK
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Fri, 1 Oct 2004 16:40:51 +0100
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@xxxxxxxxxxx> 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/
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
