修改后的清除SNIPED状态会话进程的shell脚本

#!/bin/sh
export JAVA_HOME=/usr/java
ORACLE_BASE=/oracle/ora92;export ORACLE_BASE
ORACLE_HOME=/oracle/ora92; export ORACLE_HOME
ORACLE_SID=ctais; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib64:$ORACLE_HOME/lib:$PATH; export PATH
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
LD_LIBRARY_PATH=$ORACLE_HOME/lib64:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
NLS_LANG=AMERICAN_AMERICA.US7ASCII; export NLS_LANG
TMP_DIR=/oracle/ora92/tmp;export TMP_DIR
#umask 022
cat <conn / as sysdba
spool /tmp/tmp_spid.txt
select p.spid from v$process p,v$session s
where s.paddr=p.addr
and s.status='SNIPED';
spool off
EOF
for x in `cat /tmp/tmp_spid.txt | grep "^[0123456789]"|grep -v "[a-zA-Z]"`
do
kill -9 $x
done
rm /tmp/tmp_spid.txt[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24663694/viewspace-1043467/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24663694/viewspace-1043467/