Re: ORA-04030: out of process memory errors
Date: Tue, 22 Oct 2013 09:18:06 +0200
Message-ID: <526626AE.30106_at_nordea.com>
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_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
>>>>
-- Pole na kazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> 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-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 22 2013 - 09:18:06 CEST