- Community Home
- >
- Servers and Operating Systems
- >
- Legacy
- >
- Operating System - Tru64 Unix
- >
- Which OS parameters should be modified after addon...
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
тАО05-02-2006 03:08 PM
тАО05-02-2006 03:08 PM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2006 01:37 AM
тАО05-03-2006 01:37 AM
Re: Which OS parameters should be modified after addon RAM?
max_per_proc_address_space
per_proc_address_space
max_per_proc_data_size
per_proc_data_size
These values normally are equal to the amount of memory of the system.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2006 02:28 AM
тАО05-03-2006 02:28 AM
Re: Which OS parameters should be modified after addon RAM?
If you are running a database or other application that makes heavy use of shared memory regions you might also want to adjust some of the 'ipc' kernel parameters - in particular shm_max. This should be accompanied by adjusting database/application settings that control shared memory usage.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2006 11:48 PM
тАО05-03-2006 11:48 PM
Re: Which OS parameters should be modified after addon RAM?
The swap space point above was a good one. If you're running in eager swap mode (the default), you may well need to add more swap. (If you're running in lazy mode, it won't matter.)
Martin
A quick resolution to technical issues for your HPE products is just a click away HPE Support Center
See Self Help Post for more details
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2006 04:39 AM
тАО05-08-2006 04:39 AM
SolutionIf you're running a databases and you're adding more instances or more processes per instance, then the "per_proc" parameters can probably stay the same. However if you're increasing the SGA size, then things like the number and size of shared memory segments, the optional granularity hints memory, etc. may need to be changed.
maxusers is one parameter that one could change. Although it isn't really necessary as it can be dynamically increased.
In short, tell us what you want to use the memory for and we can give better advice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2006 01:53 PM
тАО05-08-2006 01:53 PM
Re: Which OS parameters should be modified after addon RAM?
2. There is only one Oracle database(one instance) on this box. We would like to improve the database performance by enlarging the memory. So which OS parameters should we change?
Thanks
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2006 05:50 PM
тАО05-08-2006 05:50 PM
Re: Which OS parameters should be modified after addon RAM?
max_per_proc_address_space
per_proc_address_space
max_per_proc_data_size
per_proc_data_size
Also depends on what processes you are running.
All the respetive values you can find in the Administration manual (normally equivalent to RAM size).
Regards
Manish PATHAK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2006 06:01 PM
тАО05-08-2006 06:01 PM
Re: Which OS parameters should be modified after addon RAM?
If you want to use the memory to make Oracle run faster (not more clients connecting), then you can increase the SGA size and possibly the PGA (sort areas).
If you decide to increase the SGA, you need larger shared memory regions. ipc:shm_max defines the largest shared memory size. ipc:shm_mni the maximum number of those shared segments. These two multiplied will have to be able to map the entire SGA and any other shared segments you use. When you have a very large SGA, using granularity hints will be more efficient (you have to change ipc:ssm_threshold and vm:rad_gh_regions[X] to enable them).
{,max_}per_proc_address_space will need to be large enough to hold both the SGA and PGA. Note that if you decide to increase the PGA that this will increase the memory usage of every Oracle process.
You have a lot of additional memory. What's the size of your SGA now and how many Oracle processes do you have?