[20210803]如何验证.txt

[20210803]如何验证.txt

--//http://blog.itpub.net/267265/viewspace-2784877/=>[20210803]使用那个shared pool latch(补充).txt
--//我当时的测试是通过产生许多文件验证是否正确,尝试是否可以通过脚本完成,学习bash shell编程.

# egrep "HEAP DUMP|KGLH0\^|SQLA\^" /u01/app/oracle/diag/rdbms/ywdb/ywdb1/trace/ywdb1_ora_3733_0002.trc >| aa.txt
# egrep "HEAP DUMP|ds=0x" aa.txt >| bb.txt

--//拷贝bb.txt 到测试环境验证.

$ cat c1.sh
#! /bin/bash
sed -n '/HEAP DUMP heap name="sga heap(1/,/HEAP DUMP heap name="sga heap(2/p' bb.txt | grep -v "HEAP DUMP" | sed '1,$s/^.*\^//;1,$s/\".*$//' | tr 'a-z' 'A-Z' | tr -d " " | sort | uniq | xargs -IQ echo Q % 20000 % 7 +1 | sed  '1iibase=16' | bc -q | uniq -c

--//太长了,修改如下:
$ cat c1.sh
#! /bin/bash
sed -n "/sga heap($1/,/sga heap($2/p" bb.txt | grep -v "HEAP DUMP" | sed '1,$s/^.*\^//;1,$s/\".*$//' | tr 'a-z' 'A-Z' | tr -d " " | sort | uniq | xargs -IQ echo Q % 20000 % 7 +1 | sed  '1iibase=16' | bc -q | uniq -c

$ chmod 750 c1.sh

$ paste -d" " <(seq 7) <(seq 2 1 8) | xargs -IQ echo ./c1.sh Q | bash
   1877 1
   1854 2
   1694 3
   1845 4
   2002 5
   1635 6
   1654 7

--//OK,完全正确.