Re: Help me! - cursor work he,kllcqas:kllsltba

From: <fitzjarrell_at_cox.net>
Date: 23 Apr 2007 12:34:19 -0700
Message-ID: <1177356859.939585.192250@y5g2000hsa.googlegroups.com>

On Apr 23, 1:40 pm, "mtn_bik..._at_msn.com" <mtn_bik..._at_msn.com> wrote:
> > You are using too much memory, and you are fragmenting your shared
> > pool.
> > Also Oracle 8.1.7.4 is desupported since several years, as is Win2K.
> > Upgrade to something supported and/or a real operating system, or
> > switch to MTS. Most of your 200 connections are probably doing
> > nothing, apart from wasting memory.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> I have no issue? I know 8.1.7 is unsupported now, we look to upgrade
> in 1-2 months. But now we have this problem and I didn't found any
> solution.
> This problem can be cause by the application side?

Most likely your issue is the open_cursors parameter; you should probably increase your current value (to probably 500) and decrease your memory allocation.

David Fitzjarrell Received on Mon Apr 23 2007 - 14:34:19 CDT