ulimit value change for data & stack

[Vinod Kumar Yadav]

Hello friends,

I have a requirement from DBA user to
change the ulimit. The need is to change the
data and stack DBA user as follows -
data(kbytes) unlimited
stack(kbytes) unlimited

In order to change these values,The system maxdsiz and maxssiz.

kmtune |egrep -i "maxdsiz|maxssiz"|grep -v pa
maxdsiz 3221225472 - 3221225472
maxdsiz_64bit 16368709120 - 16368709120
maxssiz 401604608 - 401604608
maxssiz_64bit 1073741824 - 1073741824

Regards
Vinod

[Horia Chirculescu]

Hello,

If your DB executable is 64 bit, you should modify the _64bit variables.

If the very same executable is 32 bit, you should check for maxdsiz (data) and maxssiz (segment)

Best regards,
Horia.

[Dennis Handly]

You can't make these unlimited but you can increase the kernel parms.
Note if you increase maxssiz, you take away from maxdsiz for 32 bit processes, so 400 Mb may be too large.

>Horia: maxssiz (segment)

(This is stack.)

[Horia Chirculescu]

>(This is stack.)

Of course, stack.

Horia.