Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: STATSPACK

Re: STATSPACK

From: Ganesh Raja <ganesh.raja_at_gmail.com>
Date: Fri, 1 Oct 2004 16:40:51 +0100
Message-ID: <f754edf041001084062fe60a0@mail.gmail.com>


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
Received on Fri Oct 01 2004 - 10:41:57 CDT

Original text of this message

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