Usefull Commands on AIX for Oracle DBA.

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.)