| 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.
Nah, you're fine, or your database is fine 'cause I had cursor sharing with the same platform when I was down in Fremont. The patch is a "backport" for Linux/Oracle 8.1.7 to fix what has always worked fine on Solaris/Oracle 8.1.6.
If only I had a Sun machine again... Sigh. Steve
-----Original Message-----
Sent: Tuesday, July 03, 2001 10:37 AM
To: Multiple recipients of list ORACLE-L
Steve,
Find a good analyst and make sure they are the ones who always work your TARs.
I have yet to get an ora-600 with cursor_sharing=force on, we are on Sun Solaris 2.6 Oracle 8.1.6.0 and since it ain't broke, I'm reluctant to fix it.
Now that I have said this, the database will, of course, crash. At about 3AM
tomorrow morning.
Rachel
>From: "Orr, Steve" <sorr_at_rightnow.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 06:40:22 -0800
>
>Hi Rachel,
>
>We've got 8.1.7 on VALinux here and cursor_sharing causes ORA-600's so I
>opened a TAR 1 1/2 month ago. OWS sent us a patch but the analyst said
>there
>were "mixed results" with it... nothing like instilling confidence. The
>patch merely produced different args for the ORA-600 so I contested it with
>OWS. The TAR was in "internal review" for 2 weeks. Now they are still
>claiming the patch does the trick and are requiring me to provide them with
>a test case-- even though they admitted upfront that there were mixed
>results. So today I need to spend some time to build the test case... real
>productive work. ;-)
>
>Don't have any such problems on Solaris so I've got the sense that fixes
>are
>about a year behind on Linux. Why do I feel like I'm trying to support a
>mission critical app on the bleeding edge? Other than dogged persistence,
>any clues on how to prove bugs to OWS?
>
>Steve Orr,
>Bozeman, MT... High Tech in Big Sky Country.
>
>
>
>-----Original Message-----
>Sent: Monday, July 02, 2001 7: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: Orr, Steve
> INET: sorr_at_rightnow.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: sorr_at_rightnow.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 - 11:30:06 CDT
 |
 |