Sunday, November 18, 2012

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

No comments: