My colleagues call it CURSER_SHARING :)))
"Igor Neyman"
<ineyman@perce To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
ptron.com> cc:
Sent by: Subject: Re: Question On High Parse to
execute ratio
[EMAIL PROTECTED]
om
January 13,
2003 03:38 PM
Please respond
to ORACLE-L
Success with using CURSOR_SHARING depends on your Oracle version.
In earlier versions it's buggy.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
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).
