- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- memory utilization advice
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
тАО08-18-2003 08:59 AM
тАО08-18-2003 08:59 AM
We had 4GB of RAM and 6GB of swap configured on N class. I monitored the situation for some time and figured that we want to add memory in order to get rid of swapping. So, 2GB has been added, now we have 6GB RAM, 6GB swap, swapmem_on=1. But the swapping is still here because my DBA did changes to Oracle ( increased SGA?) and we are back to where we were before memory upgrade in terms of swapping.
Any comments/advice?
Thanks in advance.
Elena.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 09:08 AM
тАО08-18-2003 09:08 AM
Re: memory utilization advice
Approaching things from the simple side, can you get your DBA to change things back so you can at least see what effect your RAM increase had by itself and then tune from there?
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 09:23 AM
тАО08-18-2003 09:23 AM
Re: memory utilization advice
cocn03(root):/var/adm/perf> swapinfo -tam
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 1024 0 1024 0% 0 - 1 /dev/vg00/lvol2
dev 1024 194 830 19% 0 - 0 /dev/vg00/lvol10
dev 4096 193 3903 5% 0 - 0 /dev/vg03/lvol1
reserve - 4825 -4825
memory 5044 654 4390 13%
total 11188 5866 5322 52% - 0 -
DBA is saying that the reserved area for the OS ( 4825mb from a total of 11188mb ) is significantly higher than Oracle's utilization, so that we should consider reducing the reserved area. My understanding is that reserved is needed for processes (not OS) and I have no control on how much goes in reserve.
Pete, I do not think we can go back, SGA is 1.7GB.
Elena.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 09:28 AM
тАО08-18-2003 09:28 AM
Re: memory utilization advice
We've seen great improvements when raising SGA. (I wonder if the improvement is enough to tolorate the swapping)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 10:17 AM
тАО08-18-2003 10:17 AM
Re: memory utilization advice
If this were me, I would reduce shmmax so that the DBA can't pull this stunt again -- at least without letting you know beforehand.
I can absolutely assure you that any gains the DBA might have thought he achieved by increasing his cache are more than offset (by about 2 orders of magnitude) by the penalty of swapping.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 10:39 AM
тАО08-18-2003 10:39 AM
Re: memory utilization advice
It is 11.00. Buffer cache is hard set to 9.8MB (nbuf = 0, bufpages = 2400). I wish I can understand how he grabbed the memory.
Elena.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 11:13 AM
тАО08-18-2003 11:13 AM
Re: memory utilization advice
is this a standalone database server or is there additional application server software on it ? If yes, what (i.e. SAP ?)
If not, how many clients connect to the database and are these connections either handed by dedicated or multithreaded server processing ?
Check the output of top for the number of oracleSID processes and allocated memory for each process. Also compare the number to
select count(*) form v$session;
If they are close and high, you run dedicated and may consider to change to multithreaded configuration, which will reduce the number of oracle processes and the related process/context switching on OS level. Check your application documentation, if this change is permitted (with SAP it is not !).
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 11:26 AM
тАО08-18-2003 11:26 AM
Re: memory utilization advice
The way he can "grab" all that memory is that he is allowed to. You as sysadmin can limit his per process grabs by restricting maxdsiz, maxdsiz_64bit, (and to a lesser extent) maxssiz and maxssiz_64bit, and shmmax.
You can restrict those values (it's probably just shmmax) and when he attempts to start the database he will fail and be forced to reduce his init.ora parameters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 12:00 PM
тАО08-18-2003 12:00 PM
Re: memory utilization advice
shmmax = 1700000000
maxdsiz=maxdsiz_64bit=1073741824
and were setup this way as per DBA request at the Oracle/application upgrade.
Elena.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2003 12:48 PM
тАО08-18-2003 12:48 PM
SolutionThe fundamental answer to your problem is:
1) add more memory
2) reduce the current SGA usage
3) reduce the number of currently running processes
4) tolerate the swapping.
Any combination of the above can apply but 4) would be my least favorite.