- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Swap maxing out while memory only at 60...
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
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
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
10-07-2005 03:06 AM
10-07-2005 03:06 AM
Swap maxing out while memory only at 60...
Now they are having major swap issues.... My CPU util is only 60% but my swap keeps maxxing out 90-100 alerts since the upgrade. As a stopgap I added more swap to aleviate immediate issues. I currently ahve 16GB memory and I just added 3gb of swap for a total of 6gb of swap...
My question is 1) what do you think and 2) I believe I am correct in saying that oracle can allocate memory resources in at least 2 ways... 1) reserve a fixed amount of memory per thread or 2) a variable amount...
What should I tell them about how to tune it?
Any suggestions that I can offer to my dbas on how to handle this would be great.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 03:33 AM
10-07-2005 03:33 AM
Re: Swap maxing out while memory only at 60...
do you have any baseline (on memory usage ) when you run 8i ?
see this thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=952187
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 03:34 AM
10-07-2005 03:34 AM
Re: Swap maxing out while memory only at 60...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 03:37 AM
10-07-2005 03:37 AM
Re: Swap maxing out while memory only at 60...
check attachment (SGA)
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 03:39 AM
10-07-2005 03:39 AM
Re: Swap maxing out while memory only at 60...
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 03:48 AM
10-07-2005 03:48 AM
Re: Swap maxing out while memory only at 60...
this link on OTN "Oracle9i memory management"
http://www.oracle.com/technology/products/oracle9i/daily/apr15.html
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 03:51 AM
10-07-2005 03:51 AM
Re: Swap maxing out while memory only at 60...
A few month ago we moved an application from 8i to 9i. hence the result of my research (partial)
see this presentation too.
http://otn.oracle.com/products/manageability/database/pdf/ow03p/40091p.pdf
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 04:35 AM
10-07-2005 04:35 AM
Re: Swap maxing out while memory only at 60...
If you are actually seeing significant pageout rates then you need to reduce the size of the SGA or the buffer cache because nothing degrades performance like actual swapping.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 04:38 AM
10-07-2005 04:38 AM
Re: Swap maxing out while memory only at 60...
UNIX95= ps -e -o "vsz pid args" | sort
Will give you an idea of what biggest memory hogs are.
You probably checked this already but dbc_max_pct kernel parameter if your using dynamic.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 05:03 AM
10-07-2005 05:03 AM
Re: Swap maxing out while memory only at 60...
I am working with the dba to check the pga/sga sizes...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 05:11 AM
10-07-2005 05:11 AM
Re: Swap maxing out while memory only at 60...
Can you post:
swapinfo -tam
Do you have kmeminfo utility?
Rgds...Geoff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 07:48 AM
10-07-2005 07:48 AM
Re: Swap maxing out while memory only at 60...
I added 3GB of swap to stop my pager goin crazy, just as a stopgap measure until the DBAs can retune...
root> 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 1000 0 1000 0% 0 - 1 /dev/vg00/swap2
dev 1000 0 1000 0% 0 - 1 /dev/vg00/swap3
dev 3000 0 3000 0% 0 - 5 /dev/vg00/swap4
reserve - 5291 -5291
memory 12559 6079 6480 48%
total 18583 11370 7213 61% - 0 -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 07:53 AM
10-07-2005 07:53 AM
Re: Swap maxing out while memory only at 60...
How are you measuring swaps for your alerting?
Rgds...Geoff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 08:12 AM
10-07-2005 08:12 AM
Re: Swap maxing out while memory only at 60...
/dev/vg00/lvol2 device 1.0gb 0mb 1
/dev/vg00/swap2 device 1000mb 0mb 1
/dev/vg00/swap3 device 1000mb 0mb 1
/dev/vg00/swap4 device 2.9gb 0mb 5
pseudo-swap memory 12.3gb 7.4gb na
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2005 01:50 PM
10-07-2005 01:50 PM
Re: Swap maxing out while memory only at 60...
Now shared memory (SGA) is separate for each Oracle instance, and ipcs -bmop will show these spaces. Individual programs and threads will grab memory based on config parameters. CPU usage is somewhat of an indication of effective use of RAM. The whole purpose of large RAM is to avoid disk accesses by either caching needed data, or using the shared area instead of disk I/O.
But unbalanced indexes (or missing indexes) will generate partial or full searches, essentially reading the entire database for needed records. More RAM won't help--adding or balancing indexes will help enormously. This is what the DBA gets paid to do: read all the Oracle performance tuning docs and measuring long SQL procedures to see what is causing the delays. Of course, a massive load on the system may max out both disk and CPU in which case, capacity planning kicks into play and you look at a larger machine.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2005 02:01 AM
10-10-2005 02:01 AM
Re: Swap maxing out while memory only at 60...
You don't want to waste too much space double buffering. With OnLine JFS there are mount options to avoid this waste of memory and processing resources with Oracle.