Re: ORA-04030: out of process memory errors

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