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