| 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.
OK thanks. Sorry that was a dumb question.
-----Original Message-----
From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com] Sent: Tuesday, July 03, 2001 4:36 PM To: Multiple recipients of list ORACLE-LSubject: RE: CURSOR_SHARING = FORCE ques.
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" <lisa.koivu_at_efairfield.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 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:carmichr_at_hotmail.com]
> > 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" <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).
> >
> > _________________________________________________________________
> > 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: 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).Received on Tue Jul 03 2001 - 14:54:52 CDT
 |
 |