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