检测SQL--csh

 

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! -----------"