Re: ORA-04030: out of process memory errors
- From: Tom Dale <tom.dale@xxxxxxxxxxxx>
- To: sbecker6925@xxxxxxxxx
- Date: Tue, 22 Oct 2013 13:41:00 +0100
Hi Sandra,
I think I had a very similar problem, very easy to recreate.
https://forums.oracle.com/thread/2465164
Tanel's ostackprof can provide some more info of what oracle is doing.
And a
pmap -x <pid> | egrep -e "zero|anon|heap|stack"
Will show you what the os is allocating, but you will need a test case.
And as John say, its likely to be fixed in 11.2.0.4, but upgrades are not
normally quick things to implement!
Our problem happened when the sql tuning adviser was running the sql in the
maintenance window!
Tom
On Tue, Oct 22, 2013 at 8:18 AM, Remigiusz Sokolowski <
remigiusz.sokolowski@xxxxxxxxxx> wrote:
> or You may simply check the amount of swap in use
> DISM requires at least the same amount of swap as the amount of the
> memory allocated by RDBMS, while ISM not at all.
> Thus with ISM one usually needs only a small swap (let's say 4G, while
> for DISM this is more than Your SGA)
>
> On 21.10.2013 21:27, Rajesh Aialavajjala wrote:
> > 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@xxxxxxxxx
> >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@xxxxxxxxxxxx
> >>> 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@xxxxxxxxx> 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.
> >>>>
> >>>>
> >>>> --
> >>>> //www.freelists.org/webpage/oracle-l
> >>>>
>
> --
> Pole na kazi
>
> ----------------------------------------------------------------------
> Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
> pos : Senior DBA at DIiUSI
> addr : Nordea Bank Polska SA, Luzycka 6A st, 81-537 Gdynia, Poland
> phone : +48 58 667 17 43
> mobile: +48 602 42 42 77
>
> Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
> wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod
> numerem: 0000021828,
> dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku,
> VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego,
> o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych,
> NIP: 586-000-78-20, REGON: 190024711--
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
