Oracle Database Discussions

Hi ALL,

I have problem to have been caused by the database 10g shutting down due to a lack of remaining system swap space.

The unix error log /var/adm/messages shows the swap error:

# cat /var/adm/messages
Jan 4 10:56:13 amazon genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 19953 (oracle)
Jan 4 10:56:16 amazon last message repeated 7 times
Jan 4 10:56:27 amazon prngd[231]: [ID 386392 daemon.error] Could not fork: Not enough space
Jan 4 10:57:58 amazon last message repeated 1 time
Jan 4 11:03:09 amazon genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 14578 (oracle)
Jan 4 11:03:09 amazon last message repeated 7 times

The swap status can be displayed thus:

# swap -s
total: 7729336k bytes allocated + 1058208k reserved = 8787544k used, 233416k available

There is 8GB of swap, showing 97% used.

I don't know whether the database usage has grown & requires a permanent increase in swap space, or memory has been allocated over time since the last reboot and a reboot will clear it. (System uptime is 102 days.) Does anyone have a view on this?

In the meantime I've allocated an extra 8GB of swap space on the /data partition. Usage is now 50%.

# swap -s
total: 7808296k bytes allocated + 1070576k reserved = 8878872k used, 8521504k available


Thanks
Harinder Kaur