查看连接过来的应用
cat listener.log|sed -n '/11-NOV-2015 18:00/,/11-NOV-2015 19:00/p' | sed 's/\*.*SERVICE_NAME=/ /g;s/).*HOST=/ /g;s/).*$//g' | awk '{if(NF==4){print $1 " " $2 " " $3 " " $4}}'| awk '{print $3}' | sort -rn | uniq
计算应用的连接数
cat listener.log|sed -n '/11-NOV-2015 18:00/,/11-NOV-2015 19:00/p' | sed 's/\*.*SERVICE_NAME=/ /g;s/).*HOST=/ /g;s/).*$//g' | awk '{if(NF==4){print $1 " " $2 " " $3 " " $4}}'| awk '{print $3}' |grep tfr | wc -l
分析每个小时通过监听连接的数量
fgrep "21-DEC-2015" listener.log |fgrep "establish" | awk '{ print $1" " $2 }' | awk -F: '{ print $1 }' | sort | uniq -c
把分析精确到1分钟
fgrep "21-DEC-2015 16:" listener.log | fgrep "establish" | awk '{ print $1 " "$2 }' | awk -F: '{ print $1 ":" $2 }' | sort | uniq -c
针对具体时间段看什么ip连接过来的比较多
cat listener.log | grep "20-NOV-2017 16:43" | sed 's/\*.*HOST=/ /g;s/).*HOST=/ /g;s/).*$//g' | awk '{print $3}' | sort -rn | uniq -c | sort -k 1