nmon

nmon is part of aix and can shared code with topas, toggle between nmon & topas with '~'.

report top processed in a file 2 sec X 2 cycles : nmon -F aaa -c 2 -s 2 -T

official page: http://www.ibm.com/developerworks/wikis/display/WikiPtype/nmon
utils: web report - http://www.ibm.com/developerworks/wikis/display/WikiPtype/nmon_web_report


 ----
Memory

• physical:

lsattr -El sys0 -a realmem | awk {'print $2'}  (in bytes)
lsattr -El mem0 (in MBs)
svmon -G | head -2|tail -1| awk {'print $2'} ( in pages)

• in use:

svmon -G | head -2|tail -1| awk {'print $3'} (in pages)
svmon -P pid

• VM

Check Installed Compoments

select * from product_component_version

http://stackoverflow.com/questions/7800027/how-do-i-load-os-variables-into-pl-sql

select * from user_errors

Run OS command from PL/SQL: http://www.toadworld.com/Blogs/tabid/67/EntryId/356/Run-an-OS-command-from-within-PL-SQL.aspx