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 >--- 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
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: >> 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 > >T
RE: RE: CURSOR_SHARING = FORCE
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 > >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 spe
RE: RE: CURSOR_SHARING = FORCE
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
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
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
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.
>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.
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.
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).
Re: RE: CURSOR_SHARING = FORCE ques. - OCP Certification
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.