|
Linux******************************************************************************************************
--节点一11点半分析： [oracle@airfare1 /home/oracle]$ top -b -n 1 |grep oracle|awk '{print $6}'| awk 'gsub('/m'/, "") {print $0}' |awk '{sum+=$1} END {print "Sum = ", sum}'
Sum = 18903.7
[oracle@airfare1 /home/oracle]$ top -b -n 1 |grep oracle|awk '{print $7}'| awk 'gsub('/m'/, "") {print $0}' |awk '{sum+=$1} END {print "Sum = ", sum}'
Sum = 18017
[oracle@airfare1 /home/oracle]$
select 18903-18017 from dual --886
[oracle@airfare1 /home/oracle]$ free -g
total used free shared buffers cached
Mem: 23 12 10 0 0 10
-/+ buffers/cache: 2 20
Swap: 23 0 23
[oracle@airfare1 /home/oracle]$
--节点一11点半分析：
[oracle@airfare2 /home/oracle]$ top -b -n 1 |grep oracle|awk '{print $6}'| awk 'gsub('/m'/, "") {print $0}' |awk '{sum+=$1} END {print "Sum = ", sum}'
Sum = 42069.9
[oracle@airfare2 /home/oracle]$ top -b -n 1 |grep oracle|awk '{print $7}'| awk 'gsub('/m'/, "") {print $0}' |awk '{sum+=$1} END {print "Sum = ", sum}'
Sum = 39760
[oracle@airfare2 /home/oracle]$
select 42069-39760 from dual --2309
[oracle@airfare2 /home/oracle]$ free -g
total used free shared buffers cached
Mem: 23 19 3 0 0 14
-/+ buffers/cache: 5 18
Swap: 23 0 23
[oracle@airfare2 /home/oracle]$
[oracle@airfare1 /home/oracle]$ free -g
total used free shared buffers cached
Mem: 23 13 10 0 0 10
-/+ buffers/cache: 2 20
Swap: 23 0 23
[oracle@airfare1 /home/oracle]$
[oracle@airfare1 /home/oracle]$ ps -e -o 'pid,pcpu,rsz,vsz,stime,user,uid'|awk '{print $3}'|awk '{sum+=$1} END {print "Sum = ", sum}'
Sum = 177280696
[oracle@airfare1 /home/oracle]$
[oracle@airfare2 /home/oracle]$ ps -e -o 'pid,pcpu,rsz,vsz,stime,user,uid'|awk '{print $3}'|awk '{sum+=$1} END {print "Sum = ", sum}'
Sum = 495598040
[oracle@airfare2 /home/oracle]$
--##############################################################################################################################
-----------------------------------------
select 24547984/1024/1024 from dual --23g
--10:9
[oracle@airfare1 /home/oracle]$ ps -e -o 'pid,comm,args,pcpu,rsz,vsz,stime,user,uid' |grep ora_|awk '{sum+=$5} END {print "Sum = ", sum}'
Sum = 118712828=113
[oracle@airfare1 /home/oracle]$
select 118712828/1024/1024 from dual --113g
[oracle@airfare1 /home/oracle]$ ps -e -o 'pid,comm,args,pcpu,rsz,vsz,stime,user,uid' |grep LOCAL=NO|awk '{sum+=$6} END {print sum}'
60147444
[oracle@airfare1 /home/oracle]$
select 60147444/1024/1024 from dual --57G
[oracle@airfare1 /home/oracle]$ ps aux|grep oracle|grep LOCAL=NO|awk '{sum+=$6} END {print sum}'
38469148
[oracle@airfare1 /home/oracle]$
select 38469148/1024/1024 from dual --36g
--##############################################################################################################################
select 24547984/1024/1024 from dual --23g
--10:9
[oracle@airfare2 /home/oracle]$ ps -e -o 'pid,comm,args,pcpu,rsz,vsz,stime,user,uid' |grep ora_|awk '{sum+=$5} END {print "Sum = ", sum}'
Sum = 118237244
select 118237244/1024/1024 from dual --112g
[oracle@airfare2 /home/oracle]$ ps -e -o 'pid,comm,args,pcpu,rsz,vsz,stime,user,uid' |grep LOCAL=NO|awk '{sum+=$6} END {print sum}'
370857288
[oracle@airfare2 /home/oracle]$
select 370857288/1024/1024 from dual --353g
[oracle@airfare2 /home/oracle]$ ps aux|grep oracle|grep L |