Thursday, 22 August 2013

Count database processes on Linux

Count database processes on Linux:

while true
do
for z in `ps -ef | grep smon | grep -v "grep" | awk '{print $NF}' | cut -f3 -d"_" | sort`
do
CNT=0
for i in `ps -ef | grep ${z} | grep -v "grep" | awk '{print $2}'`
do
A=`ls -al /proc/${i}/status`
if [ $? = 0 ]
then
        if [ -z ${A} ]
        then
        echo "Look at: ${A}"
        #ls -al ${A}
        fi
else
 echo "Nothing to see here..."
 echo ${i}
fi
B=`ls -al /proc/${i}/smaps`
if [ $? = 0 ]
then
        if [ -z ${B} ]
        then
        echo "Look at: ${B}"
        #ls -al ${B}
        fi
else
 echo "Nothing to see here..."
 echo ${i}
fi
CNT=`expr ${CNT} + 1`
done
echo "Process count for ${z} is: "${CNT}
done
sleep 20
done

No comments:

Post a Comment