Hello Rachel,
How on earth do you ensure that the same person works your TARs? I have had very little occasion to submit TARs, however this would be a valuable bit of knowledge once I actually have a database to support.... (why do I do this again?)
Thank you
Lisa Koivu
-----Original Message-----
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: CURSOR_SHARING = FORCE ques.
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" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
_________________________________________________________________
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
