RE: STATSPACK

From: Smiley John - IL <SMILEYJ_at_tusc.com>
Date: Fri, 1 Oct 2004 10:40:12 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF168808709924AE6@tuscil_ex1>

It's impossible to give a definitive answer without a lot more information, but I would start by looking for statements with the number of parses ~= executions. Also look for literal SQL and see if cursor sharing would benefit you.

John Smiley

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh
Sent: Friday, October 01, 2004 10:05 AM
To: oracle-l_at_freelists.org
Subject: STATSPACK

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:39:35 CDT