Out of memory Oracle

[Gerry Tully]

I'm running into a problem with 3 instances of Oracle using up memory recources. The total SGA of the three is approx. 1.37gb. The system is running 32 bit processing as opposed to 64 due to home grown applications restrictions. The system is an N-Class 440 with 6gb ram running HPUX11.0. The problem occurs late in the afternoon after most of the users are off. I've attached the output from ipcs -am and my kernel parameters. I was hoping someone could take a look and see if anything obvious jumps out. Thanks in advance.

[Ted Ellis_2]

don't see anything here that inspires a target solution.. can you post the error?

[Gerry Tully]

The error message they are getting while running jobs in Oracle is:
/usr/lib/dld.sl: Call to mmap() failed -TEXT /apps/mmcprodora/8.0.6/lib/librw60.sl
/usr/lib/dld.sl: Not enough space

[John Palmer]

This sounds as though you are running out of swap space. What does swapinfo -mt tell you?

Regards,
John

[Gerry Tully]

swapinfo -mt looks like this:

Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 1024 0 1024 0% 0 - 1 /dev/vg00/lvol2
dev 8000 0 8000 0% 0 - 1 /dev/vg00/lvol9
reserve - 2682 -2682
memory 4933 1542 3391 31%
total 13957 4224 9733 30% - 0 -

[John Palmer]

Well you've got plenty of swap space!

Another possibility is that the processes are hitting the maxdsiz kernel limit (maximum data segment size). Check to see what you've got it set to (the default is 64Mb) and check your processes with glance.

In order to increase maxdsiz, you'll have to generate a new kernel and reboot.

Regards,
John

[Gerry Tully]

John, I think maxdsize is set high enough, I don't see any apparent problems in Glance.

[Ted Ellis_2]

your maxdsize is only about 100 MB... we use about 320 MB...

Oracle may be able to give you some clean recomendations for your environment

[Gerry Tully]

Ted, I think my maxdsize is around 1 gig unless I calculated wrong.

[Ted Ellis_2]

oops