Thursday, April 18, 2013

AIX Oracle memory use from ps

Wanted to make sure to grab per-process memory on the AIX server(s) for the paging investigation. 

Maxym Kharchenko has a great ora_mem.pl perl script which will account for Oracle memory usage on AIX.  However, without escalated privileges I can't run svmon, so I'm roughing it :).

d=1; while ((d<600)); do sleep 60; ps vgw | awk '{print $1, $3, $4, $5, $6, $7, $9, $10, $11, $12, $13, date}' date="`date '+%Y-%m-%d %H:%M:%S'`" >> /home/sasquatch/ps_vgw_$(date +%Y%m%d).out ; done &


Maxym's Oracle memory scripts are available here:
http://intermediatesql.com/wp-content/uploads/2010/04/ora_mem1.2.tar.gz

And his excellent series on AIX Oracle memory is listed below.

How ORACLE Uses Memory on AIX. Part 1: Processes
http://intermediatesql.com/aix/how-oracle-uses-memory-on-aix-part-1-processes/

How ORACLE Uses Memory on AIX. Part 2: SGA
http://intermediatesql.com/aix/how-oracle-uses-memory-on-aix-part-2-sga/

How ORACLE Uses Memory on AIX. Part 3: Locking SGA
http://intermediatesql.com/aix/how-oracle-uses-memory-on-aix-part-3-locking-sga/




No comments:

Post a Comment