http://intermediatesql.com/aix/how-oracle-uses-memory-on-aix-part-1-processes/ --NICE
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.)
TPLIVE3 /usr/local/bin O>svmon -G
size inuse free pin virtual
memory 1048576(2) 1031065 17511 254004 831368 (1)
pg space 2064384 388546
work pers clnt other
pin 214932 0 0 39072
in use 702494 0 328571
PageSize PoolSize inuse pgsp pin virtual
s 4 KB - 913897 388546 234788 714200
m 64 KB - 7323 0 1201 7323
TPLIVE3 /usr/local/bin O>bc
scale=2
831368/1048576 (1)/(2)
.79 --> 79% memory used
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.)
TPLIVE3 /usr/local/bin O>svmon -G
size inuse free pin virtual
memory 1048576(2) 1031065 17511 254004 831368 (1)
pg space 2064384 388546
work pers clnt other
pin 214932 0 0 39072
in use 702494 0 328571
PageSize PoolSize inuse pgsp pin virtual
s 4 KB - 913897 388546 234788 714200
m 64 KB - 7323 0 1201 7323
TPLIVE3 /usr/local/bin O>bc
scale=2
831368/1048576 (1)/(2)
.79 --> 79% memory used
No comments:
Post a Comment