In 8.1.7 the best setting of CURSOR_SHARING is "FARCE". Also, make sure that the hash sign is the first character on the line on which the parameter is set.
On 2002.07.24 20:23 "Deshpande, Kirti" wrote: > Mike, > What is the version of the database? Some versions of 8.1.7 had a few > bugs > when this parameter was set to FORCE. I suggest searching Metalink. > But it > does work as advertised in later releases. I would also recommend > reviewing > Tom Kytes' book to read about his views in using this parameter at the > instance level (my boss is reading my copy, so I can't give you page > #s). > > - Kirti > > -----Original Message----- > Sent: Wednesday, July 24, 2002 6:08 PM > To: Multiple recipients of list ORACLE-L > > > Has anyone set Cursor Sharing to Force ? > I have a new system that we have to support > and there is alot literals filling up the > pool. I have never changed this parameter > from the default as many seemed to think the > jury was still out on it. However, due to > my situation, I figured I would try it out. > If anyone has any experience with this one > I would be curious to know what happened. > > Mike > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Johnson, Michael > 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: Deshpande, Kirti > 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). > -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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).
