Message-ID: <F001.00426D40.20020313043326@fatcity.com>
Date: Wed, 13 Mar 2002 04:33:26 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: =?iso-8859-1?q?Bj=F8rn=20Engsig?= <bjorn@MiracleAS.dk>
Subject: Re: SOFT PARSE RATIO?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;
Content-Transfer-Encoding: 8bit

Here are a few indications, which I believe also were to be found in 7:

- Parse/elapsed time CPU substantial part of CPU used by this session
- parse count (almost) as large as execute count
- latch free wait time high compared to CPU used by this session and the 
latches really hit are library cache and shared pool

Thanks, Bjørn.


On Tuesday 12 March 2002 21:24, Smith, Ron L. wrote:
> Can anyone tell me more about this?  I have a 7.3.4 database that appears
> to be doing an awful lot of parsing even though it uses bind variables. How
> do I tell for sure it is doing too much parsing and is there a way to
> control it assuming the app is already using bind variables?
>
> Ron Smith
> DBA
> Kerr-McGee Corp
>
>
> -----Original Message-----
> Sent: Tuesday, March 12, 2002 1:42 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks for the correction and for your paper
>
> Regards,
> Ed
>
> > The parameter is really called session_cached_cursors and it doesn't
>
> actually
>
> > reduce the soft parses - it just decreases the serialization overhead of
> > repeated soft parses within the same session.  It's all in my paper on
>
> OTN.
>
> > Thanks, Bjørn.
> >
> > On Tuesday 12 March 2002 14:58, you wrote:
> > > Seema,
> > >
> > > I believe you can reduce that ratio by using session_cursors
> > >
> > > Regards,
> > > Ed
> > >
> > > > 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
> >
> > --
> > Bjørn Engsig, Miracle A/S
> > http://MiracleAS.dk
> > --

-- 
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@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@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).