Re: AUTOSYS performance issues
- From: Rachel Carmichael <wisernet100@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Feb 2004 06:23:41 -0800 (PST)
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
