- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Swapping space critical on DB servers
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
тАО11-12-2009 01:51 AM
тАО11-12-2009 01:51 AM
Re: Swapping space critical on DB servers
How did you deduce that more swap memory is needed? and how to do it?
Thanks in advance
Feng Lin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2009 04:57 AM
тАО11-12-2009 04:57 AM
Re: Swapping space critical on DB servers
Possibly by using the old rule of thumb of 2 X the size of RAM??
>total 25009 20623 4386 82%
You have 4 Gb free. If you aren't planning to start more processes, you may have enough.
"swapping space critical": This may mean you are low on swap.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2009 05:25 AM
тАО11-12-2009 05:25 AM
Re: Swapping space critical on DB servers
If You intend to start more process, you can increase you swap space
Are you familiar with "LVM" commands ..?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2009 05:26 AM
тАО11-12-2009 05:26 AM
Re: Swapping space critical on DB servers
Create the logical volume for your secondary swap:
# lvcreate -L 128 /dev/vgXX
NOTE: "-L 128" is the size of desired swap
Verify the logical volume:
# lvdisplay /dev/vgXX/lvolXX
Use SAM to declare your new secondary swap or use the command line:
# swapon /dev/vgXX/lvolXX
Verify it has been added in "/etc/fstab" when using SAM, or add it manually when using the command line.
Example:
/dev/vgXX/lvolXX . swap defaults 0 0
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2009 02:41 AM
тАО11-13-2009 02:41 AM
Re: Swapping space critical on DB servers
In dedicated server mode ,the UGA is allocated in the PGA and single session can demand more virtual memory depends upon the transaction/statement and number of memory objects .If you executed heavy sorting queries or highly memory intensive queries you need to have more virtual memory .
As per swa info o/p.
Your system had used more than 4GB swap memory (page out) .It indicates your system might have experienced low on physical memory than the threshold and triggered paging out operation using LRU., presumably if we have sufficient physical memory we shouldn`t need to page out ever
There are cases where the paging out can be caused by file system buffers also quite a bit.
vmstat utility gives you ├в po├в and ├в sr├в rate , if it is rising steadily during your normal operation you can decide to add more physical memory.
If your system is experiencing memory pressure then there are chances of paging out critical parts of the SGA is never good unless you use lock_sga instance parameter .
Regards,
Aneesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2009 06:03 PM
тАО11-15-2009 06:03 PM
Re: Swapping space critical on DB servers
We just did a data migration cutover. Before the data migration, there was no swap space critical alerts on the DB server. After the data migration, we start receiving the alerts. Obviously, we want to know what is causing the additional memory required.
I realise that we receive the alerts when there are 4 or more ORACLEISVCEPS processes running on the DB server. There were some changes to the schema ISVCEPS(now, it exists both the old and the new). We did some deployment changes as well.
Based on your DB expertise, are you able to help me identify where the root cause is?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2009 06:39 PM
тАО11-15-2009 06:39 PM
Re: Swapping space critical on DB servers
a) Total physical memory size
b) oracle SGA size
c) ipcs -mob
d) vmstat 5 5
e) UNIX95=1 ps -ef -o vsz,pid,ppid,state,chan,comm
f) UNIX95=1 ps -ef -o pcpu,pid,ppid,state,chan,comm
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2009 06:42 PM
тАО11-15-2009 06:42 PM
Re: Swapping space critical on DB servers
h) Append to - UNIX95=1 ps -ef -o .... | sort -rn | head 15
i) exact error messages and source
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2009 08:01 PM
тАО11-15-2009 08:01 PM
Re: Swapping space critical on DB servers
Best regards
Feng Lin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2009 08:50 PM
тАО11-15-2009 08:50 PM
Re: Swapping space critical on DB servers
You've got 2 GB of Total Memory and an SGA 1.8 GB and 5.5 GB of shared memory, 110 MB of free memory 5.0 GB Active Memory?????
Please run this command and verify your Physical memory size
Glance, m for memory, look around at the bottom of page for actual size
-or-
grep Phy /var/adm/syslog/syslog.log
-or-
dmesg | grep Phy
One of this should verify Total Memory.
#######################
Note: For sure you are out of swap. 83% Total means its time to add some more.
Also, you paged out once. 83% swap, not unexpected or unusual
The UNIX95 commands are too big. Please rerun them with appended to the end
| sort -rn | hear -15
Note: 25 GB swap.
Dude, you got a lot more RAM than you think.