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-01-2002 06:17 AM
тАО03-01-2002 06:17 AM
Thanks,
Bob
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 06:37 AM
тАО03-01-2002 06:37 AM
SolutionSet it for 67108864. This is the value that we use on a V2600 running Lawson Financials and Oracle 8.16 (8I). Memory on the box is 12GB. We have had zero performance problems since we switched from the default value for this parameter.
Also be aware that you should also be aware of the maxdsiz or maxdsiz_64bit parameters depending on whether or not your running 32 bit or 64 bit processors.
Good luck
FG.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 06:38 AM
тАО03-01-2002 06:38 AM
Re: MAXSSIZ
Since it's pretty doubtful you have that level of information - look at it from the other direction. The only negative effect from raising maxssiz is that you lose that amount of memory from the amount available for heap. (Stack starts maxssiz above the q2/q3 boundary, and grows toward higher addresses). Assuming it's not Oracle dying - that would be my first guess towards 'Most likely to be eating all it's heap' - take a look at it's heap size in glance (if you have it) or in top (though top is going to be a really rough approximation). You should be able to raise maxssiz to 1Gb - max(RES), where max(RES) is the largest RES you see in top. RES contains more than just heap, but heap tends to be the largest part.
Anyway -- sorry I can't give you more info than that, there's just no good formula. Hope this helps -- and I'd really appreciate it if you can get back (either by posting, or just mail me at don_morris@hp.com) to me with what value ended up working for you. Tunable defaults are always under discussion - and another data point helps.
Don
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 06:40 AM
тАО03-01-2002 06:40 AM
Re: MAXSSIZ
i looked into Oracle (8i) config guide and i could not find any information or MAXSSIZ specs. i found this on the HP site:
http://docs.hp.com/hpux/onlinedocs/os/KCparam.MaxSsiz.html
PS. You have the default value configured now.
Why must you alter the value, give more info please.
Gideon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 06:48 AM
тАО03-01-2002 06:48 AM
Re: MAXSSIZ
Minimum: 0x4000 (16 Kbytes)
Maximum: 0x17F00000 (about 200 Mbytes)
Default: 0x800000 (8 Mbytes)
I would start by doubling what you have right now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 06:54 AM
тАО03-01-2002 06:54 AM
Re: MAXSSIZ
Let me tell you what this does and then you can decide. First of all, maxssiz (or it's 64-bit equivalent maxssiz_64bit) consume no resources so you might be tempted to just blow it up to some really large value and forget about it. That's not a good idea because it's job is to keep all the horses in the corral. The parameter limits the maximum size of a programs stack. This is the area where essentially temporary variables are declared.
A dumb programmer will declare a local 32MB or 64MB array and if your stack is set to 8MB, your program dies. The smart programmer will ,instead. declare a dynamic array and allocate the memory. The dynamic memory is limited by maxdsiz and it is generally much larger than maxssiz. The other thing that a reasonable maxssiz prevents is runaway recursion; i.e. a function calling itself (or a pair or mutually recursive functions) over and over, each time declaring some local variables until eventually the stack is exhausted. The reason for these fence settings is to prevent any one process from grabbing all the memory and bring the box to its knees.
I consider a reasonable setting for maxssiz to be no more than 64MB. Whenever a software vendor requests a very large stack size, I politely ask to speak to their cheif developer and have him explain why their code is written this way.
Food for thought, Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 07:24 AM
тАО03-01-2002 07:24 AM
Re: MAXSSIZ
More detail? When I try to install Oracle 8.1.6, it abends with a core.
core: file from `more` - received SIGSEGV
My guess is somewhere within the install it does a 'more' on a large file and the system can't handle it. I tested it by doing a more or cat on a large file and got the same core dump.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 07:34 AM
тАО03-01-2002 07:34 AM
Re: MAXSSIZ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 07:36 AM
тАО03-01-2002 07:36 AM
Re: MAXSSIZ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2002 08:04 AM
тАО03-01-2002 08:04 AM
Re: MAXSSIZ
check out this URL:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x8bf7911284f5d5118ff40090279cd0f9,00.html
Gideon