Shell Programming and Scripting

ps -ef | awk '{ token[substr($9,length($9)-2,3)]++} END{for (i in token) print i " : " token[i] | "sort -k3nr" }' | grep -E '[A-Z]{3}'

ps -ef | awk --re-interval '$9 ~ /[A-Z]{3}/ { token[substr($9,length($9)-2,3)]++} END {for (i in token) print i " : " token[i] | "sort -k3n" }'

for osid in AAA BBB
do
   echo "$osid: $(ps -u oracle -f|grep -c $osid)"
done

awk 'NF>0 {a[$9]++}END{for (i in a) print i " : " a[i]|"sort -k3nr"}' infile

oracleAAA : 15
oracleBBB : 7
ora_ckpt_AAA : 1
ora_ckpt_BBB : 1
ora_mmon_AAA : 1
ora_psp0_AAA : 1
ora_psp0_BBB : 1
ora_qmnc_AAA : 1
ora_qmnc_BBB : 1

ps -u oracle -f| awk '/AAA/ {AAA++} /BBB/{BBB++} END {print "AAA:", AAA; print "BBB:" , BBB}'
AAA: 19
BBB: 10