- 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-11-2009 07:29 PM
тАО11-11-2009 07:29 PM
In what circumstances will we receive swapping space critical on DB servers? What does this alert mean?
Regards
Feng Lin
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2009 07:39 PM
тАО11-11-2009 07:39 PM
Re: Swapping space critical on DB servers
or improper - Kernal parameter settings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2009 07:53 PM
тАО11-11-2009 07:53 PM
Re: Swapping space critical on DB servers
In terms of performance, we added a few more jobs on the DB servers but they are schedules at different timings when we receive the alerts. That is why I need your help to throw me more light into this issue.
Regards
Feng Lin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2009 07:54 PM
тАО11-11-2009 07:54 PM
Re: Swapping space critical on DB servers
http://www.dba-oracle.com/t_server_swap_space_allocation.htm
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2009 08:00 PM
тАО11-11-2009 08:00 PM
SolutionYes - I can shed some light on OS portion only
suggestion and recommendation related to oracle you cross check with oracle support,
how much is your memeory installed
dmesg |grep -i pshyical
swapinfo -mat
what OS version?
uname -a;model
what are your currnet parmeter settings
Based on above output hope you can also shed some light on better understanding of your problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2009 09:02 PM
тАО11-11-2009 09:02 PM
Re: Swapping space critical on DB servers
I ask this because after a recent project cutover, we are receiving these alerts which we do not receive before. Our DB servers are serving customers online as well.
The main point is do we need to add memory on our DB servers ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2009 09:12 PM
тАО11-11-2009 09:12 PM
Re: Swapping space critical on DB servers
>>can too many queries on the DB servers cause swapping space critical? or just high cpu alerts ?
Yes , PGA memory is a swappable memory,if your DML operations required more PGA work area to complete ,I belive it can demand more swap memory.
How much is your swap memory utilisation ?
Aneesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2009 09:21 PM
тАО11-11-2009 09:21 PM
Re: Swapping space critical on DB servers
Performance - Not only based on the adding memory will not solve you issue,
As mentioned on above post if you could provide information asked , hope we can give some suggestion
reason for asking "performance" issue could be many reason it depends all factors ,
CPU,Memory,Swap,Kernal settings,disk, patches.. etc
I would suggestion if you escalte this issue to DBA admin, hopefully they could give clear picture - hence database inputs also important
Hope this helps
Johnson
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2009 12:46 AM
тАО11-12-2009 12:46 AM
Re: Swapping space critical on DB servers
swapinfo -mat
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 12288 4534 7754 37% 0 - 1 /dev/vg00/lvol2
reserve - 7749 -7749
memory 12721 8340 4381 66%
total 25009 20623 4386 82% - 0 -
uname -a;model
HP-UX nspppdb1 B.11.11 U 9000/800 1236689390 unlimited-user license;9000/800/rp4440
There is no info when i do 'dmesg|grep -i physical
Please advice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2009 01:44 AM
тАО11-12-2009 01:44 AM
Re: Swapping space critical on DB servers
You need more swap memory.
To get available physical memory:-
# echo phys_mem_pages/D | adb64 -k /stand/vmunix /dev/mem
phys_mem_pages:
phys_mem_pages: 524288 ---> multiply the value by 4096 to get in bytes
# bc
524288 * 4096 /1024/1024
2048 ------> 2GB physical memory
regards,
Aneesh