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/ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l