Sun box runs out of swap when starting Oracle
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