RE: CURSOR_SHARING = FORCE

[Mark Leith]

Larry,

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

>select 'x ' from dual;

'X'

x

>select 'x' from dual;

'X'

x

>select ' x' from dual;
select ' x' from dual
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [167886636], [], [], [],
[], [], []

>alter system set cursor_sharing = exact;

System altered.

>select ' x' from dual;

'X
--
 x

What can I share with you to help you out? This is on a test database only,
so just let me know. Also note that the error was only thrown on mine with a
leading space.

This is Win2K Professional SP2.

Cheers

Mark

-Original Message-
Elkins
Sent: Friday, July 27, 2001 02:56
To: Multiple recipients of list ORACLE-L


Listers,

The on again and off again topic of bugs and random errors such as the
ORA-00600 series has come up. On a Windows 2000 Server (SP2) running
8.1.7.0.0, we encountered a reproducible (on their machine) ORA-00600 error
(don't have it in front of me since I'm at home but think it was [17182] in
the first bracket) when using cursor_sharing=force.

The error would be thrown if we had a trailing space in a literal string,
boiled down to a sample case using "select 'x ' from dual". If we flipped
cursor sharing back to EXACT, the 600 error would go away, back to FORCE,
error again (slightly changing the statement's case or formatting each time
to force a hard parse). I can't reproduce here at home, also Win2000 and
8.1.7.0.0. So, while flipping cursor_sharing back and forth
solves/reproduces the problem on the client's machine, it doesn't on mine.
It appears it could be a combination of parameters/issues, in conjunction
with cursor_sharing=force, that causes FORCE to throw the 600 error and
EXACT to behave just fine. We also reproduced on a LINUX server with a copy
of the DB with all the same parameters.

A TAR was opened to get a green light on use prior to setting it to FORCE in
DEV, and while support would not guarantee no bugs would be encountered,
they weren't aware of any problems in 8.1.7.0.0. We have updated the TAR
with a test case, and have provided support with the init parameters and
their values, but, it might take some time for them (or us) to hit on the
combination. It will also be some time before the client will be able to
apply all patches. So, I was hoping someone else might have run into this
and know a combination of things that could cause the error. Otherwise, we
will need to wait until they get up to date on patches, try again, and if
the problem still reproduces, trouble-shoot with support starting from
there.

FWIW, the app uses literals *only*. Using both statspack and BSTAT/ESTAT for
info, parsing was responsible for a little more than 50% of CPU activity.
After setting to FORCE, this dropped to less than 1%. Contention on the
shared pool and library latches was greatly alleviated as well.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
  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: Mark Leith
  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).

RE: CURSOR_SHARING = FORCE

[Larry Elkins]

Mark,

Thanks for running the test. I would be interested if anyone could test on
the latest version of 8.1.7 on Win2000. I called a friend and had them test
on the latest release on HP-UX and they couldn't duplicate the bug.

My inability to duplicate on *my* machine was due to a brain cramp -- I
didn't force a hard parse of the statement like I had at the client. Cursor
sharing is set to exact on my machine. I tried the statement with the
trailing space, it worked. I then set to force and re-executed with no
problem. But, the statement wasn't hard parsed since it was found in the
shared pool. I can now duplicate without any problem by simply forcing my
statement to be hard parsed (just like I was doing on the client's
machine -- duh!):

SQL> select 'x ' from dual;  <<<<< This Works (trailing space which didn't
fail for you)

'X
--
x

SQL> alter session set cursor_sharing = force; <<<< Change to force

Session altered.

SQL> select 'x ' from dual; <<<< still works but it wasn't hard parsed.

'X
--
x

SQL> Select 'x ' from dual; <<<< force a hard parse by changing lower case s
to upper case
Select 'x ' from dual
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [366030328], [], [], [],
[], [], []

So, it looks like the problem is with just cursor sharing itself (though it
could still be a mix of parameters -- and I'm not going to try every
combination!!!).

Thanks for the help. I don't know anything else you can do. I wrapped up the
contract with the client yesterday after taking care of the major issues I
was brought in to resolve. They can handle this issue and some other minor
ones. Since I *am* curious, I will probably give their DBA a call in a week
or two to see if they and/or Oracle solved this with the latest version and
patches for 8.1.7. And maybe someone on the list will be able to test
against and up to date 8.1.7 on Win2k

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith
> Sent: Friday, July 27, 2001 10:02 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CURSOR_SHARING = FORCE
>
>
> Larry,
>
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> >select 'x ' from dual;
>
> 'X'
> 
> x
>
> >select 'x' from dual;
>
> 'X'
> 
> x
>
> >select ' x' from dual;
> select ' x' from dual
> *
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [17182], [167886636],
> [], [], [],
> [], [], []
>
> >alter system set cursor_sharing = exact;
>
> System altered.
>
> >select ' x' from dual;
>
> 'X
> --
>  x
>
> What can I share with you to help you out? This is on a test
> database only,
> so just let me know. Also note that the error was only thrown on
> mine with a
> leading space.
>
> This is Win2K Professional SP2.
>
> Cheers
>
> Mark

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  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).

Re: CURSOR_SHARING=FORCE

[Bjørn Engsig]

Harvinder,

Cursor_sharing does not reduce soft parsing, only hard parsing, and hard 
parsing is only reduced if there are statements that only differ in literals. 
 When you say query performance degrades, where do you actually loose?  
Parsing or executing?  

I suggest you read my white paper on bind variables and cursor sharing, 
available from http://otn.oracle.com/deploy/performance.

Thanks, Bjørn.

On Thursday 14 March 2002 16:13, Harvinder Singh wrote:
> Hi,
>
> We are experiencing very high value of Soft Parse and Hard Parse and we try
> to
> put CURSOR_SHARING=FORCE but that degrade the performance of queries.
> We are having 9.0.1.2.1 on Win 2k.
> What can be the other options along with Cursor_sharing to redunce soft and
> hard parse.
>
> Thanks
> --Harvinder

-- 
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?=
  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).

RE: CURSOR_SHARING=FORCE

[Jay Mehta]

We are also experimenting with CURSOR_SHARING to reduce 
excessive parsing in the application, and made few observations. It appears that 
Oracle doesn't replace literals with system generated bind variables if SQL 
statement has both literals and bind variables, as shown 
here:
 
SELECT RV_VALUE 

FROM
REF_CODES 
WHERE RV_DOMAIN = 'YESNO' 

AND RV_ABBREVIATION = 
RTRIM(:b1)
 
Jay

  -Original Message-From: Babette Turner-Underwood 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 5:38 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  CURSOR_SHARING=FORCE
  We have noticed an interesting side "effect" of using 
  CURSOR_SHARING=force.When using SQL (simple INSERT, UPDATE, SELECT...), 
  and you check v$SQLAREAyou see that yes, Oracle indeed replaced hard-coded 
  values with bindvariablesTRY: SELECT DEPTNO, LOC from DEPT where 
  LOC='Boston';select sql_text from v$sqlarea where sql_text like 'SELECT 
  DEPTNO';BUT this does not work for parameters to procedures or 
  functions.TRY:create procedure upd_dept ( in_deptno number, in_loc 
  varchar2) begin   update dept set loc = 
  in_loc;end;exec upd_dept ( 20, 'BOSTON');select sql_text from 
  v$sqlarea where sql_text like '%upd_dept%';Thus we need to change 
  calling our table APIs from :upd_dept( 20, 'BOSTON');todefine 
  my_deptno := 20;define my_location := 'BOSTON';upd_dept( :my_deptno, 
  :my_location);To use bind variables. Thus making extensive use of 
  table APIs will havemultiple copiesof SQL in shared pool UNLESS done 
  this way and CURSOR_SHARING has no effect.According to Oracle, it is how 
  it is supposed to work, but we were notexpecting the 
  behaviour.Just another one of those pleasant surprises from Oracle 
  :-)Babette[EMAIL PROTECTED]



 This electronic message contains information from CTIS, Inc., which 

may be company sensitive, proprietary, privileged or otherwise protected 

from disclosure. The information is intended to be used solely by the 

recipients named above. If you are not an intended recipient, be aware 

that any review, disclosure, copying, distribution or use of this 

transmission or its contents is prohibited.  If you have received this 

transmission in error, please notify us immediately at [EMAIL PROTECTED] 

  

Re: CURSOR_SHARING=FORCE

[Jared Still]

Oracle appears to be selective about where it uses this.

>From the docs:


CURSOR_SHARING determines what kind of SQL statements can share the same 
cursors. EXACT causes only identical SQL statements to share a cursor. 

 FORCE forces statements that may differ in some literals, but are otherwise 
identical, to share a cursor, unless the literals affect the meaning of the 
statement. 
--

I could not find any examples of what they meant by 'literals affect the 
meaning of the statement"

You may want to check MetaLink, there's quite a bit about it there.  Seems
there's a generic platform bug with CURSOR_SHARING that won't be fixed
til 8.1.7.2 in June.

Jared

 

On Thursday 26 April 2001 20:25, Jay Mehta wrote:
> We are also experimenting with CURSOR_SHARING to reduce excessive parsing
> in the application, and made few observations. It appears that Oracle
> doesn't replace literals with system generated bind variables if SQL
> statement has both literals and bind variables, as shown here:
>
> SELECT RV_VALUE
> FROM
> REF_CODES
> WHERE RV_DOMAIN = 'YESNO'
> AND RV_ABBREVIATION = RTRIM(:b1)
>
> Jay
>
> -Original Message-
> Sent: Tuesday, April 24, 2001 5:38 PM
> To: Multiple recipients of list ORACLE-L
>
>
> We have noticed an interesting side "effect" of using CURSOR_SHARING=force.
> When using SQL (simple INSERT, UPDATE, SELECT...), and you check v$SQLAREA
> you see that yes, Oracle indeed replaced hard-coded values with bind
> variables
>
> TRY: SELECT DEPTNO, LOC from DEPT where LOC='Boston';
> select sql_text from v$sqlarea where sql_text like 'SELECT DEPTNO';
>
> BUT this does not work for parameters to procedures or functions.
> TRY:
> create procedure upd_dept ( in_deptno number, in_loc varchar2)
> begin
>update dept set loc = in_loc;
> end;
> exec upd_dept ( 20, 'BOSTON');
> select sql_text from v$sqlarea where sql_text like '%upd_dept%';
>
> Thus we need to change calling our table APIs from :
>
> upd_dept( 20, 'BOSTON');
> to
> define my_deptno := 20;
> define my_location := 'BOSTON';
> upd_dept( :my_deptno, :my_location);
>
> To use bind variables. Thus making extensive use of table APIs will have
> multiple copies
> of SQL in shared pool UNLESS done this way and CURSOR_SHARING has no
> effect. According to Oracle, it is how it is supposed to work, but we were
> not expecting the behaviour.
>
> Just another one of those pleasant surprises from Oracle :-)
>
> Babette
> [EMAIL PROTECTED] 
>
>
>
>
>
> ***
>* This electronic message contains information from CTIS, Inc., which may be
> company sensitive, proprietary, privileged or otherwise protected from
> disclosure. The information is intended to be used solely by the recipients
> named above. If you are not an intended recipient, be aware that any
> review, disclosure, copying, distribution or use of this
> transmission or its contents is prohibited.  If you have received this
> transmission in error, please notify us immediately at [EMAIL PROTECTED]
> ***
>*


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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).

RE: CURSOR_SHARING = FORCE ques.

[Norwood Bradly A]

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 enabled by using 
setting CURSOR_SHARING = FORCE (either in as an initialization parameter or 
by setting it in an ALTER SYSTEM or ALTER SESSION statement), then 
statements with literals in a cursor expression can core dump. 
There 
is no workaround for thisproblem, other than disabling replacement of 
literals. Eg: "selectcursor(select 'a' from dual) from po" may 
dump    

 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 5:33 
PMTo: Multiple recipients of list ORACLE-LSubject: 
CURSOR_SHARING = FORCE ques.
Gurus 
Well the boss is now getting on my back for me to upgrade my OCP 
to 8i.  I know, I know, I wasn't going to, please don't flame me, but work 
is insisting that I do.  So now I'm studying the upgrade book and it's 
sparked up a couple of questions regarding cursor_sharing = force.
1) I've heard a bunch of negative things (like bugs) regarding 
using this feature, was this just with 8.1.6 or is it still buggy?
2) Anyone out there using it?  Does it give that much 
better performance gains?  It seems to me like it's not worth 
implementing.
3)Can the guys playing with 9i out there verify if this is buggy 
in 9i? 
Thanks to all. Ivan Rivera 

Re: CURSOR_SHARING = FORCE ques.

[Rachel Carmichael]

>
>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).

RE: CURSOR_SHARING = FORCE ques.

[John Lewis]

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 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: John Lewis
  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).

RE: CURSOR_SHARING = FORCE ques.

[Kevin Kostyszyn]

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

-Original Message-
Sent: Monday, July 02, 2001 10:38 PM
To: Multiple recipients of list ORACLE-L


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 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: John Lewis
  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: Kevin Kostyszyn
  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).

RE: CURSOR_SHARING = FORCE ques.

[Orr, Steve]

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).

RE: CURSOR_SHARING = FORCE ques.

[Kimberly Smith]

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 ORACLE-L


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 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: John Lewis
  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: Kimberly Smith
  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).

RE: CURSOR_SHARING = FORCE ques.

[Kimberly Smith]

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, July 03, 2001 6:36 AM
To: Multiple recipients of list ORACLE-L


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

-Original Message-
Sent: Monday, July 02, 2001 10:38 PM
To: Multiple recipients of list ORACLE-L


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 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: John Lewis
  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: Kevin Kostyszyn
  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: Kimberly Smith
  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).

Re: CURSOR_SHARING = FORCE ques.

[Ray Stell]

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 with
> the patch on the ftp site.
-- 

How do you analyse the effect of this parameter on the sga?
Vielen Dank!
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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).

Re: CURSOR_SHARING = FORCE ques.

[Jerry C]

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 try it out - if you 
don't like what you see, change it back...
 
 
- Jerry

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, July 02, 2001 6:32 PM
  Subject: CURSOR_SHARING = FORCE 
  ques.
  
  Gurus 
  Well the boss is now getting on my back for me to upgrade my 
  OCP to 8i.  I know, I know, I wasn't going to, please don't flame me, but 
  work is insisting that I do.  So now I'm studying the upgrade book and 
  it's sparked up a couple of questions regarding cursor_sharing = 
  force.
  1) I've heard a bunch of negative things (like bugs) regarding 
  using this feature, was this just with 8.1.6 or is it still buggy?
  2) Anyone out there using it?  Does it give that much 
  better performance gains?  It seems to me like it's not worth 
  implementing.
  3)Can the guys playing with 9i out there verify if this is 
  buggy in 9i? 
  Thanks to all. Ivan Rivera 

RE: CURSOR_SHARING = FORCE ques.

[Rachel Carmichael]

If it ain't broke, don't fix it. If you are not having problems, you have 
nothing to fix with cursor_sharing so why do it?  Remember that it exists 
and when/if you have problems, turn it on then.

My two cents


>From: Kimberly Smith <[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 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.  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 ORACLE-L
>
>
>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 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: John Lewis
>   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: Kimberly Smith
>   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).

RE: CURSOR_SHARING = FORCE ques.

[Rachel Carmichael]

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).

RE: CURSOR_SHARING = FORCE ques.

[Ivan_Rivera]

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

RE: CURSOR_SHARING = FORCE ques.

[Weaver, Walt]

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 the ones who always work your 
TARs.

Rachel


>any clues on how to prove bugs to OWS?
>
>Steve Orr,
>Bozeman, MT... High Tech in Big Sky Country.
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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).

RE: CURSOR_SHARING = FORCE ques.

[Orr, Steve]

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" <[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 acc

Re: CURSOR_SHARING = FORCE ques.

[Thater, William]

"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.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Love doesn't make the world go 'round. Love is what makes the ride
worthwhile. - Franklin P. Jones
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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).

RE: CURSOR_SHARING = FORCE ques.

[Orr, Steve]

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 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 the ones who always work your 
TARs.

Rachel


>any clues on how to prove bugs to OWS?
>
>Steve Orr,
>Bozeman, MT... High Tech in Big Sky Country.
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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).

RE: CURSOR_SHARING = FORCE ques.

[Koivu, Lisa]

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?)

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 PR

RE: CURSOR_SHARING = FORCE ques.

[Thater, William]

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 support
->(why do I do this again?)

because you ejnoy the challange.;-)  and the goddess can do anything.;-)

but seriously, *is* there a way to have the same person or persons work on you
TARs?  i've been experiencing a wide range of um... knowledge in the
people i've had.  and i get to submit them a lot.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Love doesn't make the world go 'round. Love is what makes the ride worthwhile. - 
Franklin P. Jones

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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).

RE: CURSOR_SHARING = FORCE ques.

[Seley, Linda]

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. :-)

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 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 the ones who always work your 
TARs.

Rachel


>any clues on how to prove bugs to OWS?
>
>Steve Orr,
>Bozeman, MT... High Tech in Big Sky Country.
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seley, Linda
  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).

RE: CURSOR_SHARING = FORCE ques.

[Rachel Carmichael]

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 acces

Re: CURSOR_SHARING = FORCE ques.

[Scott Shafer]

Buy the analyst mucho cervezas...


Rachel Carmichael wrote:
> 
> 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

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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).

RE: CURSOR_SHARING = FORCE ques.

[Koivu, Lisa]

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 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" <[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 th

RE: CURSOR_SHARING = FORCE ques.

[Weaver, Walt]

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, 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. :-)

Steve


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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).

RE: RE: CURSOR_SHARING = FORCE

[Jon Walthour]

Larry, et. al.,

I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following:

alter session set cursor_sharing=force;

select 'x' from dual;
select 'X' from dual;
select ' x' from dual;
select ' X' from dual;
select 'x ' from dual;
select ' x ' from dual;
select ' X ' from dual;

No problems with any of 'em.

Jon Walthour

>--- Original Message ---
>From: "Larry Elkins" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/27/01 12:41:20 PM
>

>Mark,
>
>Thanks for running the test. I would be interested if anyone
could test on
>the latest version of 8.1.7 on Win2000. I called a friend and
had them test
>on the latest release on HP-UX and they couldn't duplicate the
bug.
>
>My inability to duplicate on *my* machine was due to a brain
cramp -- I
>didn't force a hard parse of the statement like I had at the
client. Cursor
>sharing is set to exact on my machine. I tried the statement
with the
>trailing space, it worked. I then set to force and re-executed
with no
>problem. But, the statement wasn't hard parsed since it was
found in the
>shared pool. I can now duplicate without any problem by simply
forcing my
>statement to be hard parsed (just like I was doing on the client's
>machine -- duh!):
>
>SQL> select 'x ' from dual;  <<<<< this works (trailing space
which didn't
fail for you)

'x
--
x

sql> alter session set cursor_sharing = force; <<<< change to
force

session altered.

sql> select 'x ' from dual; <<<< still works but it wasn't hard
parsed.

'x
--
x

sql> Select 'x ' from dual; <<<< force a hard parse by changing
lower case s
to upper case
select 'x ' from dual
*
error at line 1:
ora-00600: internal error code, arguments: [17182], [366030328],
[], [], [],
[], [], []

so, it looks like the problem is with just cursor sharing itself
(though it
could still be a mix of parameters -- and i'm not going to try
every
combination!!!).

thanks for the help. i don't know anything else you can do. i
wrapped up the
contract with the client yesterday after taking care of the major
issues i
was brought in to resolve. they can handle this issue and some
other minor
ones. since i *am* curious, i will probably give their dba a
call in a week
or two to see if they and/or oracle solved this with the latest
version and
patches for 8.1.7. and maybe someone on the list will be able
to test
against and up to date 8.1.7 on win2k

regards,

larry g. elkins
[EMAIL PROTECTED]
> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Mark Leith
>> Sent: Friday, July 27, 2001 10:02 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RE: CURSOR_SHARING = FORCE
>>
>>
>> Larry,
>>
>> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
>> With the Partitioning option
>> JServer Release 8.1.7.0.0 - Production
>>
>> >select 'x ' from dual;
>>
>> 'X'
>> 
>> x
>>
>> >select 'x' from dual;
>>
>> 'X'
>> 
>> x
>>
>> >select ' x' from dual;
>> select ' x' from dual
>> *
>> ERROR at line 1:
>> ORA-00600: internal error code, arguments: [17182], [167886636],
>> [], [], [],
>> [], [], []
>>
>> >alter system set cursor_sharing = exact;
>>
>> System altered.
>>
>> >select ' x' from dual;
>>
>> 'X
>> --
>>  x
>>
>> What can I share with you to help you out? This is on a test
>> database only,
>> so just let me know. Also note that the error was only thrown
on
>> mine with a
>> leading space.
>>
>> This is Win2K Professional SP2.
>>
>> Cheers
>>
>> Mark
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Larry Elkins
>  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: Jon Walthour
  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).

RE: RE: CURSOR_SHARING = FORCE

[Kirsh, Gary]

On 8.1.7.1.3 on W2K:

SQL> alter session set cursor_sharing=force;

 

Session altered.

 

SQL>

SQL> select 'x' from dual;

 

'X'



x

 

SQL> select 'X' from dual;

 

'X'



X

 

SQL> select ' x' from dual;

select ' x' from dual

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [17182], [550858904], [], [], [],

[], [], []

 

 

SQL> select ' X' from dual;

select ' X' from dual

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [17182], [550858904], [], [], [],

[], [], []

 

 

SQL> select 'x ' from dual;

select 'x ' from dual

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [17182], [550858904], [], [], [],

[], [], []

 

 

SQL> select ' x ' from dual;

 

'X'



 x

 

SQL> select ' X ' from dual;

 

'X'



 X

 


Gary Kirsh
Next Extent, Inc


-Original Message-
Sent: Friday, July 27, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L




Larry, et. al.,

I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following:

alter session set cursor_sharing=force;

select 'x' from dual;
select 'X' from dual;
select ' x' from dual;
select ' X' from dual;
select 'x ' from dual;
select ' x ' from dual;
select ' X ' from dual;

No problems with any of 'em.

Jon Walthour

>--- Original Message ---
>From: "Larry Elkins" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/27/01 12:41:20 PM
>

>Mark,
>
>Thanks for running the test. I would be interested if anyone
could test on
>the latest version of 8.1.7 on Win2000. I called a friend and
had them test
>on the latest release on HP-UX and they couldn't duplicate the
bug.
>
>My inability to duplicate on *my* machine was due to a brain
cramp -- I
>didn't force a hard parse of the statement like I had at the
client. Cursor
>sharing is set to exact on my machine. I tried the statement
with the
>trailing space, it worked. I then set to force and re-executed
with no
>problem. But, the statement wasn't hard parsed since it was
found in the
>shared pool. I can now duplicate without any problem by simply
forcing my
>statement to be hard parsed (just like I was doing on the client's
>machine -- duh!):
>
>SQL> select 'x ' from dual;  <<<<< this works (trailing space
which didn't
fail for you)

'x
--
x

sql> alter session set cursor_sharing = force; <<<< change to
force

session altered.

sql> select 'x ' from dual; <<<< still works but it wasn't hard
parsed.

'x
--
x

sql> Select 'x ' from dual; <<<< force a hard parse by changing
lower case s
to upper case
select 'x ' from dual
*
error at line 1:
ora-00600: internal error code, arguments: [17182], [366030328],
[], [], [],
[], [], []

so, it looks like the problem is with just cursor sharing itself
(though it
could still be a mix of parameters -- and i'm not going to try
every
combination!!!).

thanks for the help. i don't know anything else you can do. i
wrapped up the
contract with the client yesterday after taking care of the major
issues i
was brought in to resolve. they can handle this issue and some
other minor
ones. since i *am* curious, i will probably give their dba a
call in a week
or two to see if they and/or oracle solved this with the latest
version and
patches for 8.1.7. and maybe someone on the list will be able
to test
against and up to date 8.1.7 on win2k

regards,

larry g. elkins
[EMAIL PROTECTED]
> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Mark Leith
>> Sent: Friday, July 27, 2001 10:02 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RE: CURSOR_SHARING = FORCE
>>
>>
>> Larry,
>>
>> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
>> With the Partitioning option
>> JServer Release 8.1.7.0.0 - Production
>>
>> >select 'x ' from dual;
>>
>> 'X'
>> 
>> x
>>
>> >select 'x' from dual;
>>
>> 'X'
>> 
>> x
>>
>> >select ' x' from dual;
>> select ' x' from dual
>> *
>> ERROR at line 1:
>&

RE: RE: CURSOR_SHARING = FORCE

[Chaim . Katz]

I'm on NT on
Oracle8i Enterprise Edition Release 8.1.7.1.1
and do receive: ORA-00600: internal error code, arguments: [17182]
Chaim






"Jon Walthour" <[EMAIL PROTECTED]> on 07/27/2001 02:16:03 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)






Larry, et. al.,

I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following:

alter session set cursor_sharing=force;

select 'x' from dual;
select 'X' from dual;
select ' x' from dual;
select ' X' from dual;
select 'x ' from dual;
select ' x ' from dual;
select ' X ' from dual;

No problems with any of 'em.

Jon Walthour

>--- Original Message ---
>From: "Larry Elkins" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/27/01 12:41:20 PM
>

>Mark,
>
>Thanks for running the test. I would be interested if anyone
could test on
>the latest version of 8.1.7 on Win2000. I called a friend and
had them test
>on the latest release on HP-UX and they couldn't duplicate the
bug.
>
>My inability to duplicate on *my* machine was due to a brain
cramp -- I
>didn't force a hard parse of the statement like I had at the
client. Cursor
>sharing is set to exact on my machine. I tried the statement
with the
>trailing space, it worked. I then set to force and re-executed
with no
>problem. But, the statement wasn't hard parsed since it was
found in the
>shared pool. I can now duplicate without any problem by simply
forcing my
>statement to be hard parsed (just like I was doing on the client's
>machine -- duh!):
>
>SQL> select 'x ' from dual;  <<<<< this works (trailing space
which didn't
fail for you)

'x
--
x

sql> alter session set cursor_sharing = force; <<<< change to
force

session altered.

sql> select 'x ' from dual; <<<< still works but it wasn't hard
parsed.

'x
--
x

sql> Select 'x ' from dual; <<<< force a hard parse by changing
lower case s
to upper case
select 'x ' from dual
*
error at line 1:
ora-00600: internal error code, arguments: [17182], [366030328],
[], [], [],
[], [], []

so, it looks like the problem is with just cursor sharing itself
(though it
could still be a mix of parameters -- and i'm not going to try
every
combination!!!).

thanks for the help. i don't know anything else you can do. i
wrapped up the
contract with the client yesterday after taking care of the major
issues i
was brought in to resolve. they can handle this issue and some
other minor
ones. since i *am* curious, i will probably give their dba a
call in a week
or two to see if they and/or oracle solved this with the latest
version and
patches for 8.1.7. and maybe someone on the list will be able
to test
against and up to date 8.1.7 on win2k

regards,

larry g. elkins
[EMAIL PROTECTED]
> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Mark Leith
>> Sent: Friday, July 27, 2001 10:02 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RE: CURSOR_SHARING = FORCE
>>
>>
>> Larry,
>>
>> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
>> With the Partitioning option
>> JServer Release 8.1.7.0.0 - Production
>>
>> >select 'x ' from dual;
>>
>> 'X'
>> 
>> x
>>
>> >select 'x' from dual;
>>
>> 'X'
>> 
>> x
>>
>> >select ' x' from dual;
>> select ' x' from dual
>> *
>> ERROR at line 1:
>> ORA-00600: internal error code, arguments: [17182], [167886636],
>> [], [], [],
>> [], [], []
>>
>> >alter system set cursor_sharing = exact;
>>
>> System altered.
>>
>> >select ' x' from dual;
>>
>> 'X
>> --
>>  x
>>
>> What can I share with you to help you out? This is on a test
>> database only,
>> so just let me know. Also note that the error was only thrown
on
>> mine with a
>> leading space.
>>
>> This is Win2K Professional SP2.
>>
>> Cheers
>>
>> Mark
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Larry Elkins
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>

RE: RE: CURSOR_SHARING = FORCE

[Larry Elkins]

John,

Thanks for performing the test case and satisfying my curiosity.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jon
> Walthour
> Sent: Friday, July 27, 2001 1:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: CURSOR_SHARING = FORCE
> 
> 
> 
> 
> Larry, et. al.,
> 
> I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following:
> 
> alter session set cursor_sharing=force;
> 
> select 'x' from dual;
> select 'X' from dual;
> select ' x' from dual;
> select ' X' from dual;
> select 'x ' from dual;
> select ' x ' from dual;
> select ' X ' from dual;
> 
> No problems with any of 'em.
> 
> Jon Walthour

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  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).

RE: RE: CURSOR_SHARING = FORCE

[Larry Elkins]

Thanks to all who replied. So maybe it *is* a combination of things. 

Here's a recap:

8.1.7.0.0 W2k Ser SP2 Failure
8.1.7.0.0 W2k Pro SP2 Failure
8.1.7.0.0 W2k Pro SP1 Failure
8.1.7.1.1 W2K Pro SP2 Success 
8.1.7.1.1 NT  ?   ?   Failure
8.1.7.1.3 W2K ?   ?   Failure
8.1.7.1.? HP-UX 11.0  Success 

I'll ring the DBA sometime next week and find out what Oracle has to say.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  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).

RE: RE: CURSOR_SHARING = FORCE

[Reardon, Bruce (CALBBAY)]

Larry,

On 
8.1.7.1.5 W2K Pro SP1 No errors:

SQL> select 'x ' from dual;

'X
--
x

SQL> select ' x' from dual;

'X
--
 x

SQL> alter system set cursor_sharing=force;

System altered.

SQL> Select 'x ' from dual;

'X'

x

SQL> Select ' x' from dual;

'X'

 x

SQL> 

This is in a simple test database.

If I try it on 
8.1.7.1.4 NT4 SP6a - (different parameters, different database) then I get a


SQL> select 'x ' from dual;

'X
--
x

SQL> select ' x' from dual;

'X
--
 x

SQL> alter system set cursor_sharing=force;

System altered.

SQL> Select 'x ' from dual;
Select 'x ' from dual
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [546660348], [], [], [],
[], [], []


Regards,
Bruce Reardon

-Original Message-
Sent: Saturday, 28 July 2001 9:16 

Thanks to all who replied. So maybe it *is* a combination of things. 

Here's a recap:

8.1.7.0.0 W2k Ser SP2 Failure
8.1.7.0.0 W2k Pro SP2 Failure
8.1.7.0.0 W2k Pro SP1 Failure
8.1.7.1.1 W2K Pro SP2 Success 
8.1.7.1.1 NT  ?   ?   Failure
8.1.7.1.3 W2K ?   ?   Failure
8.1.7.1.? HP-UX 11.0  Success 

I'll ring the DBA sometime next week and find out what Oracle has to say.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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).

RE: RE: CURSOR_SHARING = FORCE

[Larry Elkins]

Bruce,

Thanks for running the test. I will add this to my collection of results. 

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon,
> Bruce (CALBBAY)
> Sent: Sunday, July 29, 2001 11:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: CURSOR_SHARING = FORCE
> 
> 
> Larry,
> 
> On 
> 8.1.7.1.5 W2K Pro SP1 No errors:
> 
> SQL> select 'x ' from dual;
> 
> 'X
> --
> x
> 
> SQL> select ' x' from dual;
> 
> 'X
> --
>  x
> 
> SQL> alter system set cursor_sharing=force;
> 
> System altered.
> 
> SQL> Select 'x ' from dual;
> 
> 'X'
> 
> x
> 
> SQL> Select ' x' from dual;
> 
> 'X'
> 
>  x
> 
> SQL> 
> 
> This is in a simple test database.
> 
> If I try it on 
> 8.1.7.1.4 NT4 SP6a - (different parameters, different database) 
> then I get a
> 
> 
> SQL> select 'x ' from dual;
> 
> 'X
> --
> x
> 
> SQL> select ' x' from dual;
> 
> 'X
> --
>  x
> 
> SQL> alter system set cursor_sharing=force;
> 
> System altered.
> 
> SQL> Select 'x ' from dual;
> Select 'x ' from dual
> *
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [17182], [546660348], 
> [], [], [],
> [], [], []
> 
> 
> Regards,
> Bruce Reardon

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  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).

RE: Re: CURSOR_SHARING = FORCE ques.

[Jon Walthour]

>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 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).

RE: Re: CURSOR_SHARING = FORCE ques.

[Farnsworth, Dave]

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, 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 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: Farnsworth, Dave
  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).

RE: Re: CURSOR_SHARING = FORCE ques.

[Kevin Kostyszyn]

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  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: Kevin Kostyszyn
  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).

OT: RE: CURSOR_SHARING = FORCE ques. - OCP Certification

[Fowler, Kenneth R]

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 particular individual, but, if your company is willing to pay for you to 
pursue this then it is always (IMO) a good idea!  After all, it hopefully 
will provide you with some incentive to pick up some manuals and perhaps mess 
with a test database and learn some new stuff.  Just how could this be a 
bad thing?
 
 
Ken.
 
 
PS.  I would rather be caught with an OCP 
certification than be caught driving a tan minivan any day!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 
  6:33 PMTo: Multiple recipients of list ORACLE-LSubject: 
  CURSOR_SHARING = FORCE ques.
  Gurus 
  Well the boss is now getting on my back for me to upgrade my 
  OCP to 8i.  I know, I know, I wasn't going to, please don't flame me, but 
  work is insisting that I do.  So now I'm studying the upgrade book and 
  it's sparked up a couple of questions regarding cursor_sharing = 
  force.
  1) I've heard a bunch of negative things (like bugs) regarding 
  using this feature, was this just with 8.1.6 or is it still buggy?
  2) Anyone out there using it?  Does it give that much 
  better performance gains?  It seems to me like it's not worth 
  implementing.
  3)Can the guys playing with 9i out there verify if this is 
  buggy in 9i? 
  Thanks to all. Ivan Rivera 


LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

Re: RE: CURSOR_SHARING = FORCE ques. - OCP Certification

[Nikunj Gupta]

Title: CURSOR_SHARING = FORCE ques.



9i has come up with cursor_sharing = 
similar,
which was missing till 8i. We had FORCE and 
EXACT.  FORCE was not what most of the DBA's were willing to use. and hence 
used EXACT.  But similar will do most of the job (Assumed) that we were 
looking 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 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 particular individual, but, if your company is willing to pay 
  for you to pursue this then it is always (IMO) a good idea!  After all, 
  it hopefully will provide you with some incentive to pick up some manuals and 
  perhaps mess with a test database and learn some new stuff.  Just how 
  could this be a bad thing?
   
   
  Ken.
   
   
  PS.  I would rather be caught with an OCP 
  certification than be caught driving a tan minivan any 
day!
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 
6:33 PMTo: Multiple recipients of list 
ORACLE-LSubject: CURSOR_SHARING = FORCE 
ques.
Gurus 
Well the boss is now getting on my back for me to upgrade my 
OCP to 8i.  I know, I know, I wasn't going to, please don't flame me, 
but work is insisting that I do.  So now I'm studying the upgrade book 
and it's sparked up a couple of questions regarding cursor_sharing = 
force.
1) I've heard a bunch of negative things (like bugs) 
regarding using this feature, was this just with 8.1.6 or is it still 
buggy?
2) Anyone out there using it?  Does it give that much 
better performance gains?  It seems to me like it's not worth 
implementing.
3)Can the guys playing with 9i out there verify if this is 
buggy in 9i? 
Thanks to all. Ivan Rivera 
LEGAL NOTICEUnless 
  expressly stated otherwise, this message is confidential and may be 
  privileged. It is intended for the addressee(s) only. Access to this E-mail by 
  anyone else is unauthorized. If you are not an addressee, any disclosure or 
  copying of the contents of this E-mail or any action taken (or not taken) in 
  reliance on it is unauthorized and may be unlawful. If you are not an 
  addressee, please inform the sender 
immediately.