Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: CURSOR_SHARING = FORCE

RE: RE: CURSOR_SHARING = FORCE

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Fri, 27 Jul 2001 11:38:30 -0700
Message-ID: <F001.00357951.20010727110222@fatcity.com>

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" <jonw_at_fuse.net> on 07/27/2001 02:16:03 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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" <elkinsl_at_flash.net>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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
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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: jonw_at_fuse.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Chaim.Katz_at_Completions.Bombardier.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Fri Jul 27 2001 - 13:38:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US