Usefull Commands on AIX for Oracle DBA.

Displaying the top 10 CPU-consuming processes              
--> ps aux | head -1; ps aux | sort -rn +2 | head -10

Displaying the top 10 memory-consuming processes
--> ps aux | head -1; ps aux | sort -rn +3 | head

Displaying the top 10 memory-consuming processes using SZ
--> ps -ealf | head -1 ; ps -ealf | sort -rn +9 | head

Displaying the processes in order of being penalized          
--> ps -eakl | head -1 ; ps -eakl | sort -rn +5

Displaying the processes in order of priority              
--> ps -eakl | sort -n +6 | head

Displaying the processes in order of nice value              
--> ps -eakl | sort -n +7

Displaying the processes in order of time              
--> ps vx | head -1 ; ps vx | grep -v PID | sort -rn +3 | head -10

Displaying the processes in order of real memory use          
--> ps vx | head -1 ; ps vx | grep -v PID | sort -rn +6 | head -10

Displaying the processes in order of I/O              
--> ps vx | head -1 ; ps vx | grep -v PID | sort -rn +4 | head -10

Displaying WLM classes ( work load manager)              
--> ps -a -o pid,user,class,pcpu,pmem,args

Determining the PID of wait processes                  
--> ps vg | head -1 ; ps vg | grep -w wait


Wait processes bound to CPUs                      
--> ps -mo THREAD -p 516,774,1032,1290

Determining which processes are using the most real memory      
--> svmon -Pu -t 3|grep -p Pid|grep '^.*[0-9]'

Determining which processes use the most paging space          
--> svmon -gP -t 3 |grep -p Pid|grep '^.*[0-9]'

Displaying memory used by a WLM class                  
--> svmon -W shared

Finding out most utilized segments                  
--> svmon -S

Finding out what files a process or command is using          
--> svmon -pP

Finding out which segments use paging space              
--> svmon -gS
--> svmon -D sid (We can use the -D option to display frame information about each segment.)