Useful 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
--> 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.)
Thanks
ReplyDelete