Changing ulimit on AIX

[MCubitt]

Yesterday we changed our Oracle DBs init.ora files to increase the number of processes per DB (well, increase LIVE and decrease TEST).

Today the server locked up and we cannot even telnet in, meaning we need to reboot with a physical switch.

We suspect ulimit is the problem, currently set to 500 but with the DBs process maximums totallying 1090.

What is the correct way to up the limit? I read chsec is suggested rather than editing the file.

Any valid opinions, please?

Thanks





There's no need for sarcastic replies, we've not all been this sad for that long!

 

[MCubitt]

Actually, just checked:
bash-2.05a# ulimit -a oracle
core file size (blocks, -c) 1048575
data seg size (kbytes, -d) 131072
file size (blocks, -f) 1048575
max memory size (kbytes, -m) unlimited
open files (-n) 2000
pipe size (512 bytes, -p) 64
stack size (kbytes, -s) 32768
cpu time (seconds, -t) unlimited
max user processes (-u) 262144
virtual memory (kbytes, -v) unlimited

So no idea what it was.


There's no need for sarcastic replies, we've not all been this sad for that long!

 

[MCubitt]

It seems it was paging space:
LABEL: PGSP_KILL
IDENTIFIER: C5C09FFA

Date/Time: Wed 5 May 15:41:44 2004
Sequence Number: 1243
Machine Id: 005D87BA4C00
Node Id: IFSSERVER
Class: S
Type: PERM
Resource Name: SYSVMM

Description
SOFTWARE PROGRAM ABNORMALLY TERMINATED

Probable Causes
SYSTEM RUNNING OUT OF PAGING SPACE

Failure Causes
INSUFFICIENT PAGING SPACE DEFINED FOR THE SYSTEM
PROGRAM USING EXCESSIVE AMOUNT OF PAGING SPACE

Recommended Actions
DEFINE ADDITIONAL PAGING SPACE
REDUCE PAGING SPACE REQUIREMENTS OF PROGRAM(S)

Detail Data
PROGRAM
oracle
USER'S PROCESS ID:
123876
PROGRAM'S PAGING SPACE USE IN 1KB BLOCKS
12



Any suggestions what to do next?!


There's no need for sarcastic replies, we've not all been this sad for that long!

 

[alexhu]

Add some more paging space

AND possibly

add more memory


Alex

 

[alexhu]

What does lsps -a show ?

Alex

 

[MCubitt]

We have 8Gb memory, 1.5Gb page size. We need more disk!

Thanks


There's no need for sarcastic replies, we've not all been this sad for that long!

 

[screwloose]

Not necessarily. You need to determine your working storage and find if the memory/paging is being used by computational or non-computational pages. Then you can possibly tune vmtune based on your calculations.

 

[Chapter11]

If it's a pure Oracle server, -p 5 -P 15 is my vmtune settings.

 

[alexhu]

How big are the database SGAs ?

Alex