Labels

Friday, June 1, 2018

check the number of connection to listener file in oracle database

----Listener connection details using below UNIX command.

grep '14-OCT-2014' listener.log | grep 'establish' | awk '{print $1 " " $2 }' | awk -F: '{print $1}' | sort | uniq -c

grep '14-OCT-2014 13' listener.log | grep 'establish' | awk '{print $1 " " $2 }' | awk -F: '{print $1":"$2}' | sort | uniq -c

No comments:

Post a Comment