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

From: Karen Morton <karen_at_morton-consulting.com>
Date: Mon, 13 Jan 2003 15:24:11 -0800
Message-ID: <F001.0052E65B.20030113152411@fatcity.com>

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_at_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_at_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_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). Received on Mon Jan 13 2003 - 17:24:11 CST