| 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: Setting Cursor Sharing = Force in 8.1.7.3
Make them use bind variables. Even if cursor_sharing did work correctly
(it might in 8.1.7, but I don't remember), using bind variables will
relieve the Oracle kernel of a lot of work (i.e., response time).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
-----Original Message-----
Sent: Friday, September 27, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
We are looking into setting up cursor_sharing parameter to FORCE. Has
anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there
any
real bad effects of setting it..?
I was thinking of going back to my developers and make them use bind
variables in their code.
If I set the above parameter, they may continue to develop their code
the
way it is now.
Let me know what you all think about it..
Thanks in advance,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nat
INET: nat2710_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.com
--
Author: Cary Millsap
INET: cary.millsap_at_hotsos.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 Fri Sep 27 2002 - 16:23:37 CDT
 |
 |