- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Swap and Oracle 9.2
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
тАО03-30-2003 07:03 AM
тАО03-30-2003 07:03 AM
Swap and Oracle 9.2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-30-2003 07:16 AM
тАО03-30-2003 07:16 AM
Re: Swap and Oracle 9.2
If you have lots of memory, it is entirely possible you are not using swap. That is perfectly normal and is nothing to worry about.
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
тАО03-30-2003 09:28 AM
тАО03-30-2003 09:28 AM
Re: Swap and Oracle 9.2
Swap will also be listed out in lvlnboot under the -s option and is usually found under /dev/vg00/lvol2.
lvlnboot -v
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-30-2003 09:59 AM
тАО03-30-2003 09:59 AM
Re: Swap and Oracle 9.2
Here's the scoop: when you first install a major database or other large scale information system, add the swap recommended. In many cases, the 64bit versions of the programs may need dozens of Gb of RAM and therefore swapspace will be needed. After installation, setup your virtual memory (RAM + swap) to about 6-10Gb and then monitor using swapinfo -tam as mentioned above. This means that if you have 8Gb of RAM, swap space can be as little as 1-4Gb.
Now this does not account for memory mapped files which some applications may require--follow the manufacturer's instructions for this space. Swapping (ie, paging) is only desirable for interactive programs that have long 'think' times between activities. It is a VERY bad thing for processes that must run at full speed and can't because of lack of RAM.
Use vmstat to monitor the Page Out (po) rate over time. If the numbers are low (under 100) then all is well. If they are 3-4 digits all the time, your system is being crippled by lack of RAM. Either get a lot more RAM or stop running competing programs.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-30-2003 10:24 AM
тАО03-30-2003 10:24 AM
Re: Swap and Oracle 9.2
"Oracle does not use swap" is an ambiguous statement.
System uses swap for every process in one way or the other and there is no distinction between oracle or apache. When the system is tight on memory, swap is used to "store" the pages that are most infrequently used. This usage is different from the "reservation" of swap space that happens everytime a new process is started.
If the swap defined on your system is too large than the current swap reservation+usage, then you will find the swap utilization at 0%.
There are two indications to check if your system to tight on memory. "vmstat 2 20" and the corresponding significant 'po' column and "swapinfo -t" and non-zero figures under "KB used" column of device swaps (not memory).
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-30-2003 09:54 PM
тАО03-30-2003 09:54 PM
Re: Swap and Oracle 9.2
I always thought that all UNIX systems routinely page-out memory frames to swap in anticipation of a future page-in, even though the RAM may never actually page.
To know for sure, i used vmstat and correlate the scan rate (sr) with the page in (pi).
Also, Oracle recommends space for swap is the twice the amount of RAM.
(On systems with more than 2 GB of physical RAM memory, the requirements for Swap/Paging space can be lowered, but Swap/Paging space should never be less than physical RAM memory.)
so....
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2003 04:58 AM
тАО03-31-2003 04:58 AM
Re: Swap and Oracle 9.2
HP-UX does not "routinely page-out memory frames to swap in anticipation of a future page-in", but *reserves* swap space.
I always compare it to booking a hotel room: If I book a hotel room it is *reserved* for me (reserved room == reserved swap space), but that does not neccessarily mean that I am *in* my room (in room == paged out).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2003 05:31 AM
тАО03-31-2003 05:31 AM
Re: Swap and Oracle 9.2
Bill Hassell, sysadmin