AWR:connection management call elapsed time等待时间测试

connection management call elapsed time等待时间测试

在AWR的时间模型统计信息中，有’connection management call elapsed time‘
中这一列，现通过脚本在客户端模拟错误密码循环登录oracle，分析awr。

[oracle@db ~]$ more testcon.sh 
#!bin/bash
for i in {1..2}
do
  for j in {1..2500}
  do  
     sh conn.sh
  done
done

[oracle@db ~]$ more conn.sh 
sqlplus admin/xxx@orcl209 << EOF
  select * from v\$version;
  exit;
  EOF

[oracle@db ~]$ sh testcon.sh 

循环跑5000次之后，拉取awr，同样可以发现大量library cache lock以及connection management call elapsed time时间占比很高


同时在测试环境中db time的负载比平时立即翻了5倍

查询失败登录记录有不少

select sessionid, userid, userhost, comment$text, spare1,cast (/* TIMESTAMP */(from_tz(ntimestamp#,'00:00') at local) as date)
  from aud$
 where returncode = 1017
   and ntimestamp# > sysdate - 10;

SSD trace