- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Increase value of Oracle resource limit
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
тАО11-09-2001 08:29 AM
тАО11-09-2001 08:29 AM
Increase value of Oracle resource limit
Any help appreciated, I am using HPUX 11 on an Lclass system and also using Oracle8i.
Thanks
Babs :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2001 08:35 AM
тАО11-09-2001 08:35 AM
Re: Increase value of Oracle resource limit
I am not sure what is the exact resource you want to increase. Resources are set at two levels . At the system wide level , you increase kernel parms and that is applicable to all the users in the system.
But, you can turn the knob at the shell level too, by
using the limit command.
It's ulimit -a for posixshells(ksh,sh) and limit for cshell.
You would still need to know
what resource you want to change.
HTH
raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2001 08:38 AM
тАО11-09-2001 08:38 AM
Re: Increase value of Oracle resource limit
This is very vague. You could be talking about ulimit (in its various forms) or kernel parameters (maxdsiz, shmmax, maxssiz, maxtsiz - with 64bit extensions); you could also be talking about enabling largefiles?
Just a bit more zeroing in, please.
Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2001 08:42 AM
тАО11-09-2001 08:42 AM
Re: Increase value of Oracle resource limit
I mean the amount of concurrent processes Oracle can run.
Hope this clarifies
Babs :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2001 08:51 AM
тАО11-09-2001 08:51 AM
Re: Increase value of Oracle resource limit
This would be parameter
processes=
sessions=
in a file called init"SID".ora.
Usally processes should be set to be 10% bigger than the estimated maximum number of users to connect and sessions being some 10-20 bigger than processes.
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2001 08:52 AM
тАО11-09-2001 08:52 AM
Re: Increase value of Oracle resource limit
to all users (not just oracle). The kerenl param
which sets this is
maxuprc.
To see your current setting do
#kmtune -q maxuprc
If you need to increase it,
take a downtime and do it through SAM. On a busy system
, i have it as 2048.
-raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2001 08:55 AM
тАО11-09-2001 08:55 AM
Re: Increase value of Oracle resource limit
Okay - that could be some of the kernel paramters above including some of the msg (messages) and sem (semaphore) tunables as well. It could also be nproc and maxupc. In general, the Oracle install manual will give you pretty good values for these. There is also a tuned parameter set for database you can select in SAM and build a new kernel. It's generally a pretty good starting point with one MAJOR exception. Some of those set timeslice to 1 (it should be 10); if you choose to apply a tuned parameter set make sure that you check timeslice and reset it if necessary.
Regards, Clay