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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
