Jay, Take a look into using stored outlines. If the problem is with the vendor's code not using bind variables, I don't know that this will help, but you may find some instances where it might be useful.
I heard recently that a book should be written with just one chapter on bind variables.....Chapter 1, Page 1: Use them! The End. Karen -----Original Message----- Sent: Monday, January 13, 2003 3: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 --------------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karen Morton 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).