| 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: CURSOR_SHARING = FORCE ques.
If it ain't broke, don't fix it. If you are not having problems, you have nothing to fix with cursor_sharing so why do it? Remember that it exists and when/if you have problems, turn it on then.
My two cents
>From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: CURSOR_SHARING = FORCE ques.
>Date: Tue, 03 Jul 2001 07:21:30 -0800
>
>I am actually making them recode but with all the tasks going on it will
>take a while to get to some of the code. If I am not actually having an
>issue with the SGA is it really worth turning it on?
>
>-----Original Message-----
>Sent: Monday, July 02, 2001 7:38 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Ditto here.
>It solves the re-coding-using-vars problem. The java programmers are such
>whiners (I hope none of them read this list!).
>
>-----Original Message-----
>Sent: Monday, July 02, 2001 6:05 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
> >
> >2) Anyone out there using it? Does it give that much better performance
> >gains? It seems to me like it's not worth implementing.
>
>we're using it, on 8.1.6 No problems so far, and it relieved the problem
>of
>
>not being able to get a chunk of memory for the shared pool and having to
>flush. My programmers wrote their code using constants... on insert
>statements in a registration system. So my sqlarea was getting filled with
>identical statements, except for the value of the constant.
>
>Rather than make them recode (trust me, I would have had to get the rack
>and
>
>thumbscrews out to make that happen), I turned on cursor_sharing=force and
>it's worked like a dream.
>
>Rachel
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
>--
>Author: John Lewis
> INET: jlewis_at_punchnetworks.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
>--
>Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Tue Jul 03 2001 - 10:45:17 CDT
 |
 |