Re: Question On High Parse to execute ratio

And/or get Bjorn Engsigs article (I think it's on MiracleAS.dk under Technical Information - called cursor.pdf) about some interesting results regarding cursor sharing.

Mogens

Cary Millsap wrote:

>CURSOR_SHARING won't reduce the "parse count (total)" count; only
>eliminating parse calls from your application can do that. Using
>CURSOR_SHARING will reduce the "parse count (hard)" count (and maybe
>some shared pool latch contention), but at the expense of more user-mode
>CPU consumed during each parse.
>
>CURSOR_SHARING is an okay workaround for the interim time while you're
>fixing an application, but to really fix a parsing problem in a
>permanent way (if you have a parsing problem that needs fixing) requires
>changing the application--either by changing its source code, or by
>intercepting its db parse calls and changing their behavior. Hello,
>Anjo?
>
>For more information, hit asktom.oracle.com.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>
>Upcoming events:
>- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
>- 2003 Hotsos Symposium, Feb 9-12 Dallas
>
>
>-----Original Message-----
>Sent: Monday, January 13, 2003 2:00 PM
>To: Multiple recipients of list ORACLE-L
>
>Hello:
>
>I have a third party application which seems to have alot of unbound SQL
>
>statements, several of which do not seem to be very effective queries.
>Unfortunatelly the code is locked.
>
>My Parse to execute ratio is around 72% and I was wondering if anyone
>has
>any ideas on how I can decrease this?
>
>I figure that I might start with using the parameter CURSOR_SHARING.
>
>Any ideas would be great.
>
>Thanks in advance,
>Jay
>
>
>_________________________________________________________________
>Help STOP SPAM: Try the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).