Ulimit for Oracle

[wojtek75]

Hi,

here it is in Oracle9i 64bit env on HP 9000 Series HP-UX:
emeflxci:/flex/oraclef$kmtune | grep -i maxssiz
maxssiz 134217728 - 134217728
maxssiz_64bit 1073741824 - 1073741824

1073741824/1024=1048576

emeflxci:/flex/oraclef$ulimit -s 1048576
ksh: ulimit: exceeds allowable limit
emeflxci:/flex/oraclef$ulimit -s 208575
ksh: ulimit: exceeds allowable limit
emeflxci:/flex/oraclef$ulimit -s 108575
emeflxci:/flex/oraclef$

Why is that?
Thanks in advance.

[Avinash20]

You could set it to 131072

[Avinash20]

ulimit -s implies maxssiz

maxssiz = 134217728 / 1024 = 131072 Kb

So you can set upto 131072 only

[wojtek75]

Oracle support recommends for me:

ulimit -s 1048576

How I can make it implemented? Oracle Support recommends the following:

=================
emflxpr1:/flex/oraclef$ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1048576 <=========
stack(kbytes) 131072 <=========
memory(kbytes) unlimited
coredump(blocks) 4194303

From Note 187276.1, the minimum value for stack should be:

MAXSSIZ_64BIT=1073741824
- Defines the maximum stack segment size in bytes for 64-bit systems.

This is 1048576Kb and you can see from the output from ulimit that your setting is too low.
You should set stack to 1048576 - the same size as data:

ulimit -s 1048576

=================
Do you find it reasonable? Thanks.

[T G Manikandan]

you need to also increase maxssiz value, as the shell is 32 bit.

[Dennis Handly]

You can't use ulimit to increase kernel parms, you must use SAM to change maxssiz & maxssize_64bit.
Note: Increasing maxssiz too large will decrease the effective maxdsiz.

[Dennis Handly]

For 11.23, you can use kctune to change maxssiz & maxssize_64bit.