LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Other *NIX Forums > AIX
User Name
Password
AIX This forum is for the discussion of IBM AIX.
eserver and other IBM related questions are also on topic.

Notices

Reply
 
Search this Thread
Old 06-16-2006, 01:43 AM   #1
malru
LQ Newbie
 
Registered: May 2006
Posts: 15

Rep: Reputation: 0
High paging activity


Hi,


I'm working with a 9i RAC database with two nodes,in one
node(having 8 CPUs),paging activity is very high(reason is due to ORACLE process only) it goes to 80%,but in
another node there is no high paging activity,system admin people says the server will go down if it reaches 90%.What can i do to avoid high paging activity?

Note:
When the database is down,paging activity is normal,but only when the database is up,the paging activity is increased.

Thanks,
Malru
 
Old 06-16-2006, 09:38 AM   #2
nukkel
Member
 
Registered: Mar 2003
Location: Belgium
Distribution: Hardened gentoo
Posts: 323

Rep: Reputation: 30
Quote:
Originally Posted by malru
What can i do to avoid high paging activity?
Add more main memory.

--n
 
Old 06-17-2006, 09:36 PM   #3
crabboy
Moderator
 
Registered: Feb 2001
Location: Atlanta, GA
Distribution: Slackware
Posts: 1,823

Rep: Reputation: 120Reputation: 120
Or reduce the size of the Oracle cache.
 
Old 06-19-2006, 09:46 AM   #4
JurgyMan
Member
 
Registered: Jan 2004
Location: USA
Distribution: Gentoo
Posts: 59

Rep: Reputation: 15
file cache

modern databases will cache their own file IO...
AIX by default also wants to use a bunch of ram for FILE IO
caching... and so you waste lots of ram by double caching.

Check the values for vmo minperm and maxperm (defaults are 20/80)
I usually lower drastically via:
vmo -p -o minperm%=5 -o maxperm%=20 -o maxclient%=20
 
Old 06-19-2006, 09:52 AM   #5
Frustin
Member
 
Registered: May 2002
Location: Essex, UK
Distribution: Debian, Redhat, AIX 5L
Posts: 512

Rep: Reputation: 30
also mount your filesystems using dio (direct I/O):

Code:
/oracle:
        dev             = /dev/lvoradata
        vfs             = jfs
        log             = /dev/loglv00
        mount           = true
        options         = dio,rw
        account         = false
Here is a link to a PDF that will tell you all about it.

Last edited by Frustin; 06-19-2006 at 10:01 AM.
 
Old 06-19-2006, 10:01 AM   #6
crabboy
Moderator
 
Registered: Feb 2001
Location: Atlanta, GA
Distribution: Slackware
Posts: 1,823

Rep: Reputation: 120Reputation: 120
http://www-128.ibm.com/developerwork.../DirectIO.html
 
Old 06-19-2006, 10:01 AM   #7
JurgyMan
Member
 
Registered: Jan 2004
Location: USA
Distribution: Gentoo
Posts: 59

Rep: Reputation: 15
dio / cio

Actually, if this is a modern RAC implementation, it'd probably be better off using Concurrent IO instead of Direct IO...

http://oracle.ittoolbox.com/white-pa...urrent-io-2582
 
Old 06-19-2006, 10:47 AM   #8
crabboy
Moderator
 
Registered: Feb 2001
Location: Atlanta, GA
Distribution: Slackware
Posts: 1,823

Rep: Reputation: 120Reputation: 120
Ahh, we actually use both the old and new. Good to know.
 
  


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Load Avg High/Phys Mem High teamh Debian 2 12-26-2006 05:03 PM
RAID5 and RAID1 causing high system load on Suse 10.1 with no activity desibeli Linux - General 11 06-10-2006 01:50 PM
HDD activity causes high load squisher Linux - Hardware 1 07-14-2005 08:46 AM
Debian freezes on AMD Athlon during high disk activity rgropmair Linux - Hardware 5 06-09-2004 02:31 PM
High CPU Usage with sustained network/hdd activity? cpugeniusmv Linux - Software 6 05-19-2004 09:44 PM


All times are GMT -5. The time now is 11:10 AM.

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