| 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.
Man, if anyone goes to 8.1.7.1 make sure you get the bug fix on that version as well or you really are going to get SGA issues. They have a memory leak (both 32-bit and 64-bit). I forget the bug number buts its right there with the patch on the ftp site.
-----Original Message-----
Sent: Tuesday, July 03, 2001 6:36 AM
To: Multiple recipients of list ORACLE-L
We use it here as well on 8.1.6/8.1.7 on NT, however we do encounter a bug. It happens when you type in a simple query and try to insert an alias for one of the variables. We get an ora 600 on that bad boy, seems to be a known bug and wasn't going to be fixed until 8.1.7.1 I believe. KK
-----Original Message-----
Sent: Monday, July 02, 2001 10: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
-- 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: Kevin Kostyszyn INET: kevin_at_dulcian.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).Received on Tue Jul 03 2001 - 09:33:13 CDT
 |
 |