OCAL=NO|awk '{sum+=$6} END {print sum}'
371453480
[oracle@airfare2 /home/oracle]$
select 371453480/1024/1024 from dual --353g
top -b -n 1 |grep oracle|awk '{print "cpu:"$6"%","mem:"$7"%"}'
top -b -n 1 |grep oracle|awk '{print "cpu:"$6,"mem:"$7}'
top -b -n 1 |grep oracle|awk '{print $6,$7}'|grep -v g|grep m
top -b -n 1 |grep oracle|awk '{print $6,$7}'|awk '{ if(sub(/m/, "")) print $0'|grep -v g|grep m
top -b -n 1 |grep oracle|awk '{print $6}'| awk 'gsub('m/, "") {print $0}'
top -b -n 1 |grep oracle|awk '{print $6}'| awk 'gsub('/m'/, "") {print $0}' |awk '{sum+=$1} END {print "Sum = ", sum}'
[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 = 11739.7
top -b -n 1 |grep oracle|awk '{print $7}'| awk 'gsub('/m'/, "") {print $0}' |awk '{sum+=$1} END {print "Sum = ", sum}'
[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 = 11885
[oracle@airfare1 /home/oracle]$
select (11885-11739) from dual --146
[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 = 38898.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 = 37749
[oracle@airfare2 /home/oracle]$
select 38898-37749 from dual --1149
Aix*********************************************************************************************************************************************************
[oracle@sasis1 /home/oracle]$ svmon -U oracle
===============================================================================
User Inuse Pin Pgsp Virtual
oracle 1646398 19686 0 1596228
PageSize Inuse Pin Pgsp Virtual
s 4 KB 402862 54 0 352692
m 64 KB 77721 1227 0 77721
...............................................................................
SYSTEM segments Inuse Pin Pgsp Virtual
12977(50) 8602 0 12977
PageSize Inuse Pin Pgsp Virtual
s 4 KB 3457 42 0 3457
m 64 KB 595 535 0 595
...............................................................................
EXCLUSIVE segments Inuse Pin Pgsp Virtual
376024(1468)4396 0 355980
PageSize Inuse Pin Pgsp Virtual
s 4 KB 368584 12 0 348540
m 64 KB 465 274 0 465
...............................................................................
SHARED segments Inuse Pin Pgsp Virtual
1257397(4911)6688 0 1227271
PageSize Inuse Pin Pgsp Virtual
s 4 KB 30821 0 0 695
m 64 KB 76661 418 0 76661
...............................................................................
EXCLUSIVE segments Inuse Pin Pgsp Virtual
376024 4396 0 355980
PageSize Inuse Pin Pgsp Virtual
s 4 KB 368584 12 0 348540
m 64 KB 465 274 0 465
Vsid Esid Type Description PSize Inuse Pin Pgsp Virtual
971377 10 clnt text data BSS heap, s 13931 0 - -
/dev/oraclelv:23611
9815d8 11 work text data BSS heap sm 13763 0 0 13763
941674 11 work text data BSS heap sm 13763 0 0 13763
9c16dc 11 work text data BSS heap sm 13759 0 0 13759
971397 11 work text data BSS heap sm 13020 0 0 13020
8814e8 11 work text data BSS heap sm 11050 0 0 11050
8c13ac 11 work text data BSS heap sm 9944 0 0 9944
831403 11 work text data BSS heap sm 9936 0 0 9936
921552 11 work text data BSS heap sm 8458 0 0 8458
8215a2 11 work text data BSS heap sm 8411 0 0 8411
9e1abe 11 work text data BSS heap sm 8006 0 0 8006
8514c5 11 work text data B |