RE: CURSOR_SHARING = FORCE

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
elkinsl_at_flash.net


> -----Original Message-----

> From: root_at_fatcity.com [mailto:root_at_fatcity.com]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: elkinsl_at_flash.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).