- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Kernel parameters and SGA size
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
тАО06-05-2002 10:53 PM
тАО06-05-2002 10:53 PM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2002 11:02 PM
тАО06-05-2002 11:02 PM
Re: Kernel parameters and SGA size
You have to increase the SHMMAX, this is the maximum size of a single shared memory segment and directly converts to the Shared memory that Oracle can use.
If you also want to increase the total number of shared memory segments, increase SHMMNI, this is number of shared memory indentifiers on the system.
Hope this helps.
...BPK...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2002 11:15 PM
тАО06-05-2002 11:15 PM
Re: Kernel parameters and SGA size
What your say about maxdsiz_64bit?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2002 11:37 PM
тАО06-05-2002 11:37 PM
SolutionOn a 4GB L2000 running Oracle( 32 bit) and Java application we use maxdsiz of 1GB. But this value was decided after tuning the Java application.
I am not so sure if tuning of maxdsiz is required for Oracle. I suggest you try running it with 1 GB and see.
...BPK...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 01:26 AM
тАО06-06-2002 01:26 AM
Re: Kernel parameters and SGA size
you may check the following document on the Oracle Metalink Web site :
doc id 68105.1
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 02:14 AM
тАО06-06-2002 02:14 AM
Re: Kernel parameters and SGA size
SHMAX of 1gb is ok. Search for my kernel configuration and use the parameters. Remember your swap space has to be increased.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 02:38 AM
тАО06-06-2002 02:38 AM
Re: Kernel parameters and SGA size
Oracle is not started if increase SGA parameters (for instance - pool size) - not enough memory. shmmax is set 1 Gb.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 02:46 AM
тАО06-06-2002 02:46 AM
Re: Kernel parameters and SGA size
As long as the use of the database don't change (number of users) and all you want to do is enlarge the SGA (preferably the db_block_buffers) into the new 6GB of RAM, increase the SHMMAX kernel parameter to 6GB or at least the value you plan have for your new SGA.
Thus getting the SGA into a single shared memory segment.
The SHMMNI should be left unchanged as the number of shared memory segments don't change (unless you add another database)
To avoid having to add lots of swap space to accomodate the processes be sure to set swapmem_on = 1 in your kernel. This turns on psuedo swap and allows for more processes to be started than there is infact swapspace available for. You don't want your SGA to swap anyway so why set aside swapspace for it!
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 02:53 AM
тАО06-06-2002 02:53 AM
Re: Kernel parameters and SGA size
I assume that if you're using Oracle you're an Oracle customer (with support) abnd therefore you can register to Metalink !
Lots of stuff if you are an Oracle DBA !
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 02:55 AM
тАО06-06-2002 02:55 AM
Re: Kernel parameters and SGA size
What are the changes that you have done before restarting the database ?
What is the error message that is being displayed ?
...BPK...