Count number of client connections to oracle Database on a server
countproc.sh
#/bin/ksh
# count # of processes for each database
for i in ` pgrep -fl smon|awk -F_ '{print $3}'`
do
echo "database name : " $i
ps -ef|grep $i|grep LOCAL=NO |wc -l
done
Rupam
