ulimit setting for Oracle

[Binubaby]

Hello
I want to set ulimit on an alpha server ES40 Tru64 5.1b PK4 with 2gb of RAM to setup oracle.
Please infom how to configure ulimit for user oracle what are the syntax i can use
It gives me error: limit exeeds
Which shell I can use for oracle?
How can I keep the values permenant

Please help
Thanks
Bins

[Vladimir Fabecic]

How to configure ulimit for user oracle?
Give some more details. You got error limit exeeds after what?
Did you look at man pages of ulimit and sys_attrs_proc?
You can use any shell for oracle. I ussualy use ksh.
You can keep values permanent if you put line with ulimit in .profile of oracle user.

[Joris Denayer]

Bins,

I suppose you want to increase the size of the data-segment. This can be incresed if you are superuser. Another user cannot increase the datasegment.

You also cannot go higher than the value defined by the sysconfigtab variable max_per_proc_data_size.

As previously mentioned, these parameters are explained in # man sys_attrs_proc

The parameter values to implement should be described in the installation manual of Oracle.

[Binubaby]

Hello
Thanks for the help, I have put the ulimit values in the .profile and it worked.
My DBA informed that he is experiencing performance problem
Current : Tru64 5.1b PK4, Oracle 10g OracleAS
Any further performance tuning required or any idea about updating PK5

Thanks
Bins