The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Operating Systems > AIX
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #4 (permalink)  
Old 05-07-2008
indulis indulis is offline
Registered User
  
 

Join Date: May 2008
Posts: 4
Memory tuning for Oracle

Normally running Oracle on AIX 5.3, you need to do some memory tuning so that you don't "double up" in buffering files. General rule is to reduce AIX amount of mem used to buffer IO and put this into Oracle's file buffers (in the SGA). This is because Oracle knows better what to cache, as it is its own data.

I don't recommend changin the following parameter by itself but it is (IMHO) the most important new parameter for an ERP/OLTP server (Introduced in AIX 5.3 ML1 and AIX 5.2 ML4).
vmo –p –o lru_file_repage=0

This means that program memory requests (e.g. Oracle file buffers) get priority over AIX's own file buffers. This is the behaviour you'd want.

Of course there are a whole heap of other parameters you'd want to check so please DO NOT just run this command without understanding what the other settings are.

And the previous post was right, just looking at "free memory" in AIX doesn't tell you much at all as AIX will try to use all memory all the time.

I hope you are using DIO or CIO access from Oracle if using JFS2 to hold your data (and DIO if using JFS). Also Asynch I/O.

Last edited by indulis; 05-07-2008 at 08:30 AM.. Reason: correction