Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- tmpfile=/tmp/tmp.$$
- sqlplus system/manager <
- spool $tmpfile
- 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 $tmpfile | grep "^[0123456789]"`
- do
- kill -9 $x
- done
- rm $tmpfile
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement