Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0E3mYU19503 for ; Mon, 13 Jan 2003 21:48:34 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0E3mYc19498 for ; Mon, 13 Jan 2003 21:48:34 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA82353; Mon, 13 Jan 2003 16:29:02 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052E65B; Mon, 13 Jan 2003 15:24:11 -0800 Message-ID: Date: Mon, 13 Jan 2003 15:24:11 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Karen Morton" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Karen Morton" Subject: RE: Question On High Parse to execute ratio Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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: fish_dba@hotmail.com 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: karen@morton-consulting.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@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).