Re: ORA-04030: out of process memory errors

From: Rajesh Aialavajjala <r.aialavajjala_at_gmail.com>
Date: Mon, 21 Oct 2013 15:27:55 -0400
Message-ID: <CAGvtKv6McnMnooX_NHNdvnxf6-E8EJyaGtbfUawLUVoyWir1LQ_at_mail.gmail.com>

Sandra,
 This link might be useful to validate if DISM or ISM is in use in your environment...
http://www.oracle.com/technetwork/articles/systems-hardware-architecture/using-dynamic-intimate-memory-sparc-168402.pdf

Page 7 - How to Check if ISM and DISM Are In Use

Thanks,

--Rajesh

On Mon, Oct 21, 2013 at 2:00 PM, Sandra Becker <sbecker6925_at_gmail.com>wrote:

> We did verify the total SGA was not over allocated. Not sure about ISM or
> DISM. We (the DBAs) knew the swap was too low, but needed some ammunition
> to get that changed. Reading through the links given to me now. Thank
> you.
> Sandy
>
>
> On Mon, Oct 21, 2013 at 11:34 AM, Mark Bobak <Mark.Bobak_at_proquest.com
> >wrote:
>
> > Hi Sandy,
> >
> > Swap messages are definitely bad. The server should *not* be swapping.
> >
> > I have some concerns about a server that has 128G of RAM, and only 8GB of
> > swap. (Oracle recommended swap space for a system w/ more than 16GB of
> > RAM is 16GB of swap.)
> >
> > Also, how many instances are running on this server? How much total SGA
> > is allocated?
> >
> > Is ISM (Intimate Shared Memory) or DISM (Dynamic Intimate Shared Memory)
> > being used?
> >
> > -Mark
> >
> >
> > On 10/21/13 1:08 PM, "Sandra Becker" <sbecker6925_at_gmail.com> wrote:
> >
> > >Solaris 5.10, 128G RAM, 8G swap
> > >Oracle EE 11.2.0.2
> > >We've been getting the ORA-04030 errors several times a week since they
> > >did
> > >an OS patch in August. The SE team says there isn't anything wrong with
> > >the server or configuration on their side, although they do see some
> swap
> > >messages in their logs. Other than the OOM errors, we don't see any
> > >issues
> > >in the database.
> > >
> > >What should we be looking at/for to determine the cause? The databases
> > >and
> > >server they are running on have been in place for at least of couple of
> > >years. Does anyone know of memory issues with this version of Solaris?
> > >
> > >Thanks in advance for any suggestions or ideas.
> > >--
> > >Sandy
> > >Transzap, Inc.
> > >
> > >
> > >--
> > >http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
> --
> Sandy
> Transzap, Inc.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 21 2013 - 21:27:55 CEST