cat test.sh
#!/bin/csh
echo "-------- BEGIN! -----------"
foreach sid ( `onstat -g sql|grep -v vi|grep -i $1|awk '{print $1}'`)
foreach used_flag ( `onstat -g sql $sid|grep $2|wc -l|awk '{print $1}'`)
if $used_flag then
echo "onstat -g sql" $sid
onstat -g sql $sid|grep $2
endif
end
end
echo "-------- finish! -----------"
#!/bin/csh
echo "-------- BEGIN! -----------"
foreach sid ( `onstat -g sql|grep -v vi|grep -i $1|awk '{print $1}'`)
foreach used_flag ( `onstat -g sql $sid|grep $2|wc -l|awk '{print $1}'`)
if $used_flag then
echo "onstat -g sql" $sid
onstat -g sql $sid|grep $2
endif
end
end
echo "-------- finish! -----------"