- Community Home
- >
- Servers and Operating Systems
- >
- Legacy
- >
- Operating System - Tru64 Unix
- >
- Safe usage of 'max_proc_per_user'
Operating System - Tru64 Unix
1753262
Members
4792
Online
108792
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО02-02-2004 10:04 AM
тАО02-02-2004 10:04 AM
Safe usage of 'max_proc_per_user'
I have a system that is being pounded with oracle queries and at times has a load at or near 12. I'm getting 'max_proc_per_user' exceeded messages, but I'm concerned that allowing more processes will continue to overload the 2 1gig CPUs I have in my ES-45 box with 4GB RAM.
Any thoughts?
Any thoughts?
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2004 06:37 PM
тАО02-02-2004 06:37 PM
Re: Safe usage of 'max_proc_per_user'
maybe there is a tuning mismatch on your system. be sure you have configured the database and the system as described in the oracle tuning guide.
There are dependencies within the max_proc_per_user parameters. But maybe there is another problem leading to the increased processes. Please verify if tcp timeout is an issue here leading to processes in WAIT state.
There are dependencies within the max_proc_per_user parameters. But maybe there is another problem leading to the increased processes. Please verify if tcp timeout is an issue here leading to processes in WAIT state.
Help() { FirstReadManual(urgently); Go_to_it;; }
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2004 06:52 PM
тАО02-02-2004 06:52 PM
Re: Safe usage of 'max_proc_per_user'
Hi,
I know, it makes you feel uneasy to see the machine at it's limit, however 'max_proc_per_user' exceeded messages are worse bacause you never know, when they hit. I would first of all check if oracle is running with good performance. We have a 4cpu/4gb 4100 and only after I tuned indexes and oracle configuration, the machine is now running smoothly.
Michael
I know, it makes you feel uneasy to see the machine at it's limit, however 'max_proc_per_user' exceeded messages are worse bacause you never know, when they hit. I would first of all check if oracle is running with good performance. We have a 4cpu/4gb 4100 and only after I tuned indexes and oracle configuration, the machine is now running smoothly.
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-03-2004 04:38 AM
тАО02-03-2004 04:38 AM
Re: Safe usage of 'max_proc_per_user'
The limit that is hit here is a per-user limit NOT a system limit.
So what user is this logged against ? Do all your clients connect with the same username ?
Can't you give different usergroups another collective username against which they could authenticate ?
If you increase max_proc_per_user, you should also check max_threads_per user. By default it's 4 times max_proc_per_user and it should at least be larger than max_proc_per_user. (See man sys_attrs_proc)
Probably the dependencies Ralf was thinking about are those that come with maxusers, which in turn influences taskmax, threadmax and min_free_vnodes, but nowadays maxusers is selfconfiguring at boot-time based on the available physical memory.
Rgds,
Johan.
_JB_
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP