Re: ORA-04030: out of process memory errors

  • From: Mark Bobak <Mark.Bobak@xxxxxxxxxxxx>
  • To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 21 Oct 2013 17:36:36 +0000

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@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
>>
>>
>>
>>
>


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


Other related posts: