Oracle Listener连接风暴的分析

$vi conn.shsqlplus sys/system@192.168.10.130:1521/orcl as sysdbaselect * from v\$version;exit;$vi conn1.shsqlplus sys/system@192.168.10.130:1521/orcl1 as sysdbaselect * from v\$version;exit;$vi conn2.shsqlplus sys/system@192.168.10.130:1521/orcl2 as sysdbaselect * from v\$version;exit;
复制

$vi connect.shfor i in {1..200000}dofor j in {1..40}dosh home/oracle/conn.shdonedoneEOF$vi connect1.shfor i in {1.. 200000}dofor j in {1. .40}dosh home/oracle/conn1.shdonedoneEOF…$vi connect2.shfor i in {1.. 200000}dofor j in {1. .40}dosh home/oracle/conn2.shdonedoneEOF…
复制

nohup sh connect.sh > /dev/null 2>&1&nohup sh connect1.sh > /dev/null 2>&1&nohup sh connect2.sh > /dev/null 2>&1&
复制

[oracle@orcl:/u01/app/oracle/diag/tnslsnr/orcl/listener/trace]$ tail -20f listener.log
复制

$grep '18-FEB-2022'  listener.log | sed 's/\*.*SERVICE_NAME=/ /g;s/).*HOST=/ /g;s/).*$//g'   | awk '{if(NF==4){print "insert into t_tab values('\''"$1"'\'','\''"$2"'\'','\''"$3"'\'','\''"$4"'\'');"}}'   > /home/oracle/insert.sql
复制

Create table t_tab( a1 varchar2(50),a2  varchar2(50),a3  varchar2(50),a4  varchar2(50));@/home/oracle/insert.sql
复制

select  a1,substr(a2,1,5),a3,count(1) from t_tab where a3 in ('orcl','orcl1','orcl2') group by a1,substr(a2,1,5),a3 order by count(1) desc;
复制