- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Ulimit for Oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2009 06:40 AM
тАО03-10-2009 06:40 AM
Ulimit for Oracle
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2009 06:46 AM
тАО03-10-2009 06:46 AM
Re: Ulimit for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2009 06:47 AM
тАО03-10-2009 06:47 AM
Re: Ulimit for Oracle
maxssiz = 134217728 / 1024 = 131072 Kb
So you can set upto 131072 only
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2009 06:56 AM
тАО03-10-2009 06:56 AM
Re: Ulimit for Oracle
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2009 07:36 AM
тАО03-10-2009 07:36 AM
Re: Ulimit for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2009 08:12 AM
тАО03-10-2009 08:12 AM
Re: Ulimit for Oracle
Note: Increasing maxssiz too large will decrease the effective maxdsiz.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2009 08:19 AM
тАО03-10-2009 08:19 AM