with CURSOR_SHARING.
- Original Message -
From:
Fowler, Kenneth R
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 03, 2001 08:50
AM
Subject: OT: RE: CURSOR_SHARING = FORCE
ques. - OCP Certification
Why
is it that people seem to have the ne
Uh oh -- I keep forgeting there are other former GWL'ers on the list...
;>)
--Walt Weaver
Bozeman, Montana, USA
-Original Message-
Sent: Tuesday, July 03, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
That's what I've always heard!
Linda
(same building, different floors, d
Title: RE: CURSOR_SHARING = FORCE ques.
OK thanks. Sorry that was a dumb question.
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: CURSOR_SHARING = FORCE
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
RACLE-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 b
That's what I've always heard!
Linda
(same building, different floors, doesn't count!)
-Original Message-
Sent: Tuesday, July 03, 2001 11:58 AM
To: Multiple recipients of list ORACLE-L
LOL!
Well, I'm not alone... actually everybody that works with Walt needs some
serious counselling
XACTLY!!
-Original Message-
Walthour
Sent: Tuesday, July 03, 2001 2:23 PM
To: Multiple recipients of list ORACLE-L
>is it friday yet?;-)
If you get tomorrow off for the Fourth of July, it's kinda like
a Friday today.
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
And if you don't get the fouth off, it's very much like Tuesday. :o(
-Original Message-
Sent: Tuesday, July 03, 2001 1:23 PM
To: Multiple recipients of list ORACLE-L
>is it friday yet?;-)
If you get tomorrow off for the Fourth of July, it's kinda like
a Friday today.
Jon Walthour,
On Tue, 3 Jul 2001,Koivu, Lisa scribbled on the wall in glitter crayon:
->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 s
Title: RE: CURSOR_SHARING = FORCE ques.
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
>is it friday yet?;-)
If you get tomorrow off for the Fourth of July, it's kinda like
a Friday today.
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat Ci
LOL!
Well, I'm not alone... actually everybody that works with Walt needs some
serious counselling. :-)
Steve
-Original Message-
Sent: Tuesday, July 03, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
Rachel,
We all agree here that Steve needs a good analyst. We're helping hi
"Weaver, Walt" wrote:
>
> Rachel,
>
> We all agree here that Steve needs a good analyst. We're helping him look
> for one. :>)
when you find one let me know. i need all the help i can get!;-)
is it friday yet?;-)
--
Bill "Shrek" Thater Certifiable ORACLE DBA
Telergy, Inc.[EMA
ients 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 a
Rachel,
We all agree here that Steve needs a good analyst. We're helping him look
for one. :>)
--Walt Weaver
Bozeman, Montana, USA
-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 t
Title: RE: CURSOR_SHARING = FORCE ques.
Thanks to all who responded. I've gotten mixed reviews, basically it's great as long as it's working right (no bugs). I wonder how it works on 9i? Thanks again everyone. Ivan
e 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
[EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: CURSOR_SHARING = FORCE ques.
>Date: Tue, 03 Jul 2001 07:21:30 -0800
>
>I am actually making them recode but with all the tasks going on it will
>take a while to get to some of the code.
Title: CURSOR_SHARING = FORCE ques.
I've used it here quite a bit, w/ version
8.1.6. Most of the time it helps (expecially Broadvision apps, where I've seen
SQL cache miss rates go from 50-70% to <10%). I've had one occasion where my
miss rate actually went *up*. It's a dynamic parameter, so
On Tue, Jul 03, 2001 at 07:31:23AM -0800, Kimberly Smith wrote:
> 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 wit
Title: CURSOR_SHARING = FORCE ques.
Why is
it that people seem to have the need to apologize after admitting that they are
OCP certified (or are working toward the goal etc). I know that there are
a lot of differing opinions regarding OCP and what it may or may not tell you
about a particul
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
I am actually making them recode but with all the tasks going on it will
take a while to get to some of the code. If I am not actually having an
issue with the SGA is it really worth turning it on?
-Original Message-
Sent: Monday, July 02, 2001 7:38 PM
To: Multiple recipients of list ORA
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 contes
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
-Ori
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
>
>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. M
Title: CURSOR_SHARING = FORCE ques.
You're probably referring to this bug, Ivan, I haven't
seen a fix via MetaLink.
Somewhere I read a recommendation of
cursor_sharing=exact, but can't pinpoint
that
advice.
BUG 984132Description: If
automatic replacement of literals with bind variables is
28 matches
Mail list logo