Oracle-L: RE: Question On High Parse to execute ratio

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Mon, 13 Jan 2003 15:09:38 -0800
Message-ID: <F001.0052E610.20030113150938@fatcity.com>

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: Jay Wade
INET: fish_dba_at_hotmail.com

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Cary Millsap
INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------