Re: ORA-04030: out of process memory errors

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