um, call at the same time every time and hope?
make friends with the analyst so that you can email them privately and ask
them to review any TAR you submit?
>From: "Koivu, Lisa" <[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 10:37:16 -0800
>
>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).
_________________________________________________________________
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).
