1748201 Members
2912 Online
108759 Solutions
New Discussion юеВ

Re: Ulimit for Oracle

 
wojtek75
Frequent Advisor

Ulimit for Oracle

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.
6 REPLIES 6
Avinash20
Honored Contributor

Re: Ulimit for Oracle

You could set it to 131072
"Light travels faster than sound. That's why some people appear bright until you hear them speak."
Avinash20
Honored Contributor

Re: Ulimit for Oracle

ulimit -s implies maxssiz

maxssiz = 134217728 / 1024 = 131072 Kb

So you can set upto 131072 only
"Light travels faster than sound. That's why some people appear bright until you hear them speak."
wojtek75
Frequent Advisor

Re: Ulimit for Oracle

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
Honored Contributor

Re: Ulimit for Oracle

you need to also increase maxssiz value, as the shell is 32 bit.
Dennis Handly
Acclaimed Contributor

Re: Ulimit for Oracle

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
Acclaimed Contributor

Re: Ulimit for Oracle

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