Re: SOFT PARSE RATIO?

It's only a problem if you spend too much time doing parsing; the mere ratio tells you nothing.

But if you do spend too much time parsing, (or waiting for library cache or shared pool latch; maybe even row cache latch) you need to look at how your applications are written. The simple answer is that anything that repeats frequently must be parsed once per session only. I wrote a white paper on this issue while I was at Oracle, go to otn.oracle.com/deploy/performance and pick 'Efficient use of bind variables and cursor sharing'. It also mentions the init.ora parameters that can somehow help.

Thanks, Bjørn.

On Monday 11 March 2002 23:34, you wrote:
> Hi
> In our database I found SOFT PARSE RATION is 62% which is lower than
> normal.What could be problem and how to correct this problem?Please
> suggest. Thx
> -Seema
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx

-- 
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?=
  INET: bjorn_at_MiracleAS.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).