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

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

STATSPACK

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Fri, 01 Oct 2004 11:04:59 -0400
Message-ID: <BAY19-F3MbzjqruzTvz0001ca44@hotmail.com>


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

Original text of this message

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