Wednesday, November 11, 2009

Oracle memory usage AIX

The following link contains a collection of scripts that calculate oracle memory usage on AIX.

mem.zip :  https://drive.google.com/file/d/0B8hdAvkza6deal9SeFBzWDg2MkU/edit?usp=sharing


The file mem.rar contains:

instance_mem_use.sh
This script is used to measure memory usage of oracle instance asm instance , background processes , dedicated processes and also dbconsole processes.

Usage: instance_mem_use.sh dbsid dbname

In most cases dbsid=dbname but if you have a RAC node the dbsid differs from dbname.

Sample output :

/home/oracle $./instance_mem_use.sh RMINTPRD2 RMINTPRD
Memory Analysis for RMINTPRD2

Oracle Instance Memory
-----------------------------------------------------
System Global Area Memory Usage :5008MB
Program Global Area Memory Usage :500MB
-----------------------------------------------------

Oracle Processes Memory
-----------------------------------------------------
ORACLE Background Processes : 29
Memory Usage : 435MB

ORACLE Dedicated Processes : 154
Memory Usage : 1318MB

ORACLE dbconsole Processes : 1
Memory Usage : 5MB
-----------------------------------------------------


#####################################################
RMINTPRD2 Total Memory Usage :7268MB
#####################################################

other_mem_use.sh

This script is used to measure LISTENER,RMAN or CRS processes.

Usage: other_mem_use.sh LISTENER or CRS or RMAN

Sample otuput :

/home/oracle $ ./other_mem_use.sh CRS

-----------------------------------------------------
ORACLE CRS Processes : 18
CRS Total Memory Usage :202MB
-----------------------------------------------------

These scripts are used for the caclucations.

mem.awk
mem_calc.awk



References

Metalink note 123754.1 : AIX: Determining Oracle memory usage on AIX

5 comments:

  1. you have a nice site. thanks for sharing this valuable resources. keep it up. anyway, various kinds of ebooks are available here

    http://feboook.blogspot.com

    ReplyDelete
  2. Thanks for your scripts. could you tel me how to lunch mem.awk or mam_calc.awk ?

    ReplyDelete
    Replies
    1. Hi,

      these scripts are invoked from the main shell script.
      Agis

      Delete
  3. Dear Agis,
    thank you very much for sharing your knowledge. Do you see a possibility to re-upload your memory calculation scripts for AIX? I'm currently in a task to make better use of existing memory on a 4 node RAC system and of cause I don't want to overallocate ;-)
    Thank you very much!

    ReplyDelete