- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: adding memory to rx4640 - oracle performance i...
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-09-2009 08:18 AM
тАО06-09-2009 08:18 AM
We added memory to an HPUX 11.23 rx4640 system, from 32GB to 64GB and now we are seeing some performance issues within oracle.
Any kernel parms needing to be changed? Any parms in general need to be changed? My thought is that the Oracle SGA needs to be modified but what about on the OS itself?
Thanks all!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2009 08:51 AM
тАО06-09-2009 08:51 AM
SolutionAdding memory to a system normally does not provoke performance issues but:
shmmax may need to be increased. This will open up more shared memory for Oracle to use.
swap may need to be expanded. Oracle now has more memory to use, but it needs to reserve swap space and there may not be enough.
http://www.hpux.ws/?p=6
This script will enable you to collect some additional data.
I would gather some Oracle performance data before modifying the SGA. I would also use cstm/mstm or xstm to test the new memory is working right.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2009 09:12 AM
тАО06-09-2009 09:12 AM
Re: adding memory to rx4640 - oracle performance issues
Many thanks! Kind of what I was thinking as well. I have been collecting these stats for some time and I am not seeing much difference in the stats from before or after memory install. The parm I would be most interested in (from an OS view) would be the shmmax as it is currently set to 34GB dynamic and is currently using 49%.
Again, many thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2009 03:49 PM
тАО06-09-2009 03:49 PM
Re: adding memory to rx4640 - oracle performance issues
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2009 05:49 AM
тАО06-11-2009 05:49 AM