Re: Sun box runs out of swap when starting Oracle

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Mon, 26 Sep 2011 16:59:20 -0700 (PDT)
Message-ID: <b4d3a4fe-010a-47c1-a5a9-1ec4fbfdfe8d_at_n36g2000yqb.googlegroups.com>

On Sep 26, 6:36 pm, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:
> 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)

Open an SR with Oracle? Received on Mon Sep 26 2011 - 18:59:20 CDT