LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices

Reply
 
LinkBack Search this Thread
Old 11-11-2011, 05:06 AM   #1
aamerjavaid
Member
 
Registered: Dec 2005
Posts: 53

Rep: Reputation: 15
Significant virtual memory paging was detected on the RHEL 4.8


Hi Guys,

We are member of DB Team, and are investigating some performance issues on Database Server.

My current question is regarding Virtual Memory Paging, how can i determine what is in RAM, how to calculate what is composed of total RAM utilization and what is composed of total SWAP utilization?

Can i see what was the status of RAM/SWAP in some particular point in time?

What tools/techniques are available for Diagnosing SWAP Space?

Code:
Our System Config
=================
RAM 32G
SWAP 32G         (Previously was 16G 2 Months before)
Processor 32
HDD Direct Attached and 50% usage
Let me add, 2 months back, our Database started crashing, that time we had 16G SWAP, but when we created File based SWAP of 16G, it Database started working Normally without any issues.


Recommendations we got from Oracle Perspective.
Quote:
Significant virtual memory paging was detected on the host operating system.
RECOMMENDATION 1: Host Configuration, 100% benefit (38349 seconds)
ACTION: Host operating system was experiencing significant paging but no particular root cause could be detected. Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory. Also consider adding more physical memory to the host.
Thanks,
Amir
 
Old 11-11-2011, 10:08 PM   #2
aamerjavaid
Member
 
Registered: Dec 2005
Posts: 53

Original Poster
Rep: Reputation: 15
Hi Guys,

Can you please guide me on this.

Thanks,
Amir
 
Old 12-03-2011, 01:59 PM   #3
bweddell
LQ Newbie
 
Registered: Jul 2011
Posts: 11

Rep: Reputation: Disabled
My current question is regarding Virtual Memory Paging, how can i determine what is in RAM, how to calculate what is composed of total RAM utilization and what is composed of total SWAP utilization?
Assuming this is still happening, you can try 'top' and sort by memory (capital M to sort). Pay attention to the VIRT column.

Can i see what was the status of RAM/SWAP in some particular point in time?
By status of RAM/SWAP are you wanting to see what is used/remaining overall or do you want to get more granular (i.e. what processes comprise usage of each)? You can use sar -r -f /var/log/sa/sa## to look back at overall utilization.

What tools/techniques are available for Diagnosing SWAP Space?
In terms of swap, are you using any? I'd recommend you do a sar -W (realtime) or sar -W -f /var/log/sa/sa## (historical) to get more info or look at top. You can also look for kswapd processes from top which will indicate to you if the kernel is trying to swap.
 
Old 12-03-2011, 07:43 PM   #4
syg00
LQ Veteran
 
Registered: Aug 2003
Location: Australia
Distribution: Lots ...
Posts: 11,801

Rep: Reputation: 923Reputation: 923Reputation: 923Reputation: 923Reputation: 923Reputation: 923Reputation: 923Reputation: 923
As you are DBA(s) and presumably will understand the database specifics of this. I like it as I ain't a DBA.

For your specific question, I doubt you will be able to accurately determine swap usage at the likely kernel level you are on. This support only recently became available for individual processes.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Paging and Segmentation: Virtual Memory Linux josecolella Linux - General 1 11-03-2011 12:49 PM
Virtual memory in RHEL wtb Red Hat 9 11-04-2009 10:25 AM
Memory paging questions. RepSTOSW Linux - Kernel 1 06-15-2009 02:43 AM
Swapping vs Paging vs Virtual Memory SBN Linux - General 4 04-05-2008 09:06 AM
virtual memory paging problem on install j_hart Linux - Software 0 10-13-2003 01:52 AM


All times are GMT -5. The time now is 05:33 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration