- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- SHMMAX kernel parameter & 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
Forums
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
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
тАО08-10-2004 03:44 PM
тАО08-10-2004 03:44 PM
SHMMAX kernel parameter & Oracle
I trust I am in the correct forum category, as most of the similar threads I searched for came from this one.
Anyway, I am running 64-bit 11.0 with 2GB physical RAM. Current value of SHMMAX is 0x77000000 (> 6GB).
Is there any potential risks if I leave the value as it is?
All replies appreciated.
Shahril
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-10-2004 03:55 PM
тАО08-10-2004 03:55 PM
Re: SHMMAX kernel parameter & Oracle
How much swap have got configured?
How is the system performing generally?
How big is the database?
How many users?
What is dbc_max_pct set as?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-10-2004 04:27 PM
тАО08-10-2004 04:27 PM
Re: SHMMAX kernel parameter & Oracle
No benefit either.
I would trim it down to something reasonable (pick a number between 400MB and 2000MB: Oracle will just allocated additional segments if it needs to) at your earliest convenience, but not reason to panic/reboot for this.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-10-2004 04:32 PM
тАО08-10-2004 04:32 PM
Re: SHMMAX kernel parameter & Oracle
As you question said SHMMAX kernel parameter and Oracle, here is something in brief as to how SHMMAX parameter value effects oracle.
SHMMAX defines the maximum size of a single shared memory segment. The SHMMAX setting should be large enough to hold the entire SGA in one shared memory segment. A low setting can cause creation of multiple shared memory segments which may lead to performance degradation.
Oracle documents says the minimum required for 9i single instance on Solaris is 4Gb and on HP-UX 11.0 (64-bit) is Availmem. The maximum is limited by available physical memory and OS limits
Semaphores and shared memory are two very distinct sets of Operating System resources.
Semaphores are a system resource that Oracle utilizes for interprocess communication and they occupy a relatively small memory space, while shared memory is utilized to contain the SGA and can garner a large portion of physical memory.
SHARED MEMORY and how is shared memory allocated by the OS varies slightly depending on Unix platform, but the basic premise is this:
An application requests a given amount of contiguous shared memory from the OS. The OS dictates how large of a shared memory segment it will allow with the kernel parameter SHMMAX(Shared Memory Maximum). If the amount of shared memory requested by the application is greater than SHMMAX, the OS may be granted the shared memory in multiple segments. Ideally, however, you want the amount requested by the application to be less than SHMMAX so that the application's request can be fulfilled with one shared memory segment.
Since the SGA is comprised of shared memory, SHMMAX can potentially limit how large your SGA can be and/or prevent your instance from starting.
The following limits the size of SGA. In no particular order.
1. The amount of Physical Memory and Swap space available on your system.
2. The kernel paramater SHMMAX.
3. Other OS specific limitations on shared memory.
I hope this hleps to some extent.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-10-2004 04:39 PM
тАО08-10-2004 04:39 PM
Re: SHMMAX kernel parameter & Oracle
The OS will ignore any setting in excess of 25% of memory. Memory is defined by HP-UX as RAM plus swap.
based on what you post I don't think changing SHMMAX will do any good at all.
Your system is in need of a full tune.
Attaching a data collection script that can help with that.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com