#!/bin/ksh
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/7.3.3
export ORACLE_SID=dojv
PATH=$PATH:~:$ORACLE_HOME/bin:/etc

svrmgrl command=@ssv ; # produces ssv.log

#   From: v$statname we see that:
#   9, 36 logical, physical reads
# 139,140 memory, disk sorts
# 118,119 short, long table scans

ssv.pl

tail -289 dev.raw > dev.rm0
awk '{
 if (NR == 1) {v1 = $2; v2 = $3}
 if (NR  > 1) {printf("%-20s %12d %12d\n",$1,$2-v1,$3-v2);v1 = $2; v2 = $3}
}' dev.rm0 | sort -r > dev.rm1
dev.pl > dev.htm
ftp -n -v 167.10.6.50 <<EOF
user  oracle ******
ascii
put dev.htm dojv/dev.htm
quit
EOF

tail -289 srv.raw > srv.rm0
awk '{
 if (NR == 1) {v1 = $2; v2 = $3}
 if (NR  > 1) {printf("%-20s %12d %12d\n",$1,$2-v1,$3-v2);v1 = $2; v2 = $3}
}' srv.rm0 | sort -r > srv.rm1
srv.pl > srv.htm
ftp -n -v 167.10.6.50 <<EOF
user  oracle ******
ascii
put srv.htm dojv/srv.htm
quit
EOF

tail -289 tsv.raw > tsv.rm0
awk '{
 if (NR == 1) {v1 = $2; v2 = $3}
 if (NR  > 1) {printf("%-20s %12d %12d\n",$1,$2-v1,$3-v2);v1 = $2; v2 = $3}
}' tsv.rm0 | sort -r > tsv.rm1
tsv.pl > tsv.htm
ftp -n -v 167.10.6.50 <<EOF
user  oracle ******
ascii
put tsv.htm dojv/tsv.htm
quit
EOF