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

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Mon, 13 Jan 2003 12:38:42 -0800
Message-ID: <F001.0052E340.20030113123842@fatcity.com>

Success with using CURSOR_SHARING depends on your Oracle version. In earlier versions it's buggy.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, January 13, 2003 3:00 PM

> 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: Igor Neyman
  INET: ineyman_at_perceptron.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 - 14:38:42 CST