Sun box runs out of swap when starting Oracle

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Mon, 26 Sep 2011 15:36:59 -0700 (PDT)
Message-ID: <7a75195b-5487-4c6d-b2d6-1bd6d8af527a_at_t11g2000yqk.googlegroups.com>



We have legacy system running Oracle 9.2.0.8. It is being migrated to new M5000 (Solaris 10). We are running Oracle on the physical server, not on Solaris Zone. The server has 128 GB memory, Oracle is configured with 50 GB SGA, 30 GB buffer cache, and 3 GB shared pool.
"top" shows that around 80 GB memory is free. Swap is 8 GB, all free. Following Solaris tradition we have several tmpfs filesystems:
Filesystem           kbytes    used   avail capacity  Mounted on
swap                 18452376     448 18451928     1%    /etc/svc/
volatile
swap                 18451928       0 18451928     0%    /tmp
swap                 18451992      64 18451928     1%    /var/run

This is test server and it is idle, there are no connections to the database, I am the only person connected to the server.

When I tried to start Oracle with 70 GB SGA it started but server run out of swap.

/var/adm/messages contains:

tmpfs: [ID 518458 kern.warning] WARNING: /etc/svc/volatile: File system full, swap space limit exceeded
genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 2291 (scopeux)

alert.log contains:

ORA-04030: out of process memory when trying to allocate 48000 bytes (pga heap,non-vector post process batch)

The server stopped responding and we had to restart it.

Any suggestion what could be done to avoid this problem? (other than increasing swap to 128 GB) Received on Mon Sep 26 2011 - 17:36:59 CDT

Original text of this message