Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-04031 errors
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