| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Question On High Parse to execute ratio
My colleagues call it CURSER_SHARING :)))
"Igor Neyman"
<ineyman_at_perce To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
ptron.com> cc:
Sent by: Subject: Re: Question On High Parse to execute ratio
root_at_fatcity.c
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
ineyman_at_perceptron.com
> 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: Rajesh.Rao_at_jpmchase.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 - 16:13:56 CST
 |
 |