Re: ORA-04031 errors

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 25 Aug 1999 12:34:53 -0400
Message-ID: <37C41B2C.B2EFEC32@Unforgettable.com>

Brian McCabe wrote:

> Personally, I would investigate the use of the shared pool a little more. If
> you have large packages which are failing to obtain segments then it might
> just be that the space is getting too fragmented. Take a look at
> DBMS_SHARED_POOL package to pin frequently used, large objects in memory at
> startup.
>
> In the longer term, if your SGA continues to grow and grow, ythen it might
> be worth reviewing the application code to ensure that it follows some kind
> of standards which should allow for re-use of parsed commands.
>
> Jeff Hunter <jeffh_at_btitelecom.net> wrote in message
> news:37c355c4_at_defiant.btitelecom.net...
> > If it were my installation, I would increase the SGA size. The fact that
> > the users are getting this error is indicitive that those objects really
> > need to be in the SGA.
> >
> >
> >

Thanks. This is useful information. There are not a large number of packages/procedures, but some of the ones that are used are used a lot and would be worth pinning.

Ken Received on Wed Aug 25 1999 - 11:34:53 CDT