Check the size of your shared pool. Do you have big enough shared pool
to keep parsed SQL statements for re-use or they are flushed out
because of a small library cache and are parsed when loaded again.
- "Smith, Ron L." <rlsmith_at_kmg.com> 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
> > --
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Edward Shevtsov
> INET: ed.shevtsov_at_mail.ru
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> 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).
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammed Shakir
INET: mshakir08816_at_yahoo.com
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).
Received on Wed Mar 13 2002 - 20:53:28 CST
