RE: ORA-04030: out of process memory errors

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Mon, 21 Oct 2013 17:43:21 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD118787FB7_at_G6W2491.americas.hpqcorp.net>

The following Oracle support note might be useful if the link Mark pointed to does not provide enough information

Note: 1088267.1 Master Note for Diagnosing OS Memory Problems and ORA-4030

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark Bobak Sent: Monday, October 21, 2013 1:37 PM
To: sbecker6925_at_gmail.com; oracle-l
Subject: Re: ORA-04030: out of process memory errors

Also, this link may be useful:
http://docs.oracle.com/cd/E23824_01/html/821-1459/fsswap-31555.html

On 10/21/13 1:34 PM, "Bobak, Mark" <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
>>
>>
>>
>>
>

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


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

Received on Mon Oct 21 2013 - 19:43:21 CEST