|
[oracle-l]
||
[Date Prev]
[10-2004 Date Index]
[Date Next]
||
[Thread Prev]
[10-2004 Thread Index]
[Thread Next]
RE: STATSPACK
- From: Smiley John - IL <SMILEYJ@xxxxxxxx>
- To: "'oracledbam@xxxxxxxxxxx'" <oracledbam@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 1 Oct 2004 10:40:12 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Seema Singh
Sent: Friday, October 01, 2004 10:05 AM
To: oracle-l@xxxxxxxxxxxxx
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
|
|
