I last used it successfully in 8.1.7.3 (I think it was .3), but it was
a very "plain vanilla" system... the Java programmers refused to use
prepared statements, it was a registration system so I was seeing
thousands and thousands of "select .... where login_id='literal'"
statements. I lost the fight to have the programmers recode (damn
startups and impossible deadlines) so turned on cursor_sharing=FORCE
stopped all those pesky shared pool out of memory errors.
- Mladen Gogala <mladen_at_wangtrading.com> wrote:
> On 02/20/2004 08:31:39 AM, Thomas Jeff wrote:
> > Niall,
> >
> > I agree with avoiding FORCE, it's a solution of the last resort,
> too
> > many side effects.
>
> On 9.2.0.4, it works perfecly well, without those pesky ora-600. As
> any
> new feature, it needed to mature a bit to be useful.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 20 2004 - 08:23:41 CST