Re: share memory fragmentation

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 22 Jun 2009 07:05:30 -0700 (PDT)
Message-ID: <630f192f-3c3a-4e54-9c1d-e125b0531759_at_f16g2000vbf.googlegroups.com>

On Jun 21, 3:03 am, patrick boulay <boul..._at_free.fr> wrote:
> has anyone came accross a share memory fragmentation ?
> We have this issue sometime with a 300G SGA instance ( non RAC )

By shared memory fragmentation I suspect you have encountered ORA-04031 errors. If so, you should have posted the error and what has been done so far to deal with the issue.

We have had numerous Service Requests with Oracle support related to ORA-04031 errors. The default response from support is to just increase the size of your shared pool but in the end all of our problems have traced back to bugs.

The bugs were Oracle version specific.

One general action that helps environments that use a log of packaged code to to pin via dbms_shared_pool all heavily used and all very large packages into the shared pool on instance startup.

HTH -- Mark D Powell -- Received on Mon Jun 22 2009 - 09:05:30 CDT