| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CURSOR_SHARING = FORCE
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'
>select 'x' from dual;
'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 elkinsl_at_flash.net 214.954.1781 -- 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: Mark Leith INET: mark_at_cool-tools.co.uk 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 - 08:46:09 CDT
 |
 |