RE: STATSPACK

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Fri, 1 Oct 2004 16:47:00 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E8F4A6A@louis.cerebrus.com>

Looks like you need to start using bind variables

Your soft parse % is too low

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh Sent: 01 October 2004 16:05
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!=20 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:45:12 CDT