kill_all_session_by_username.sh
用于杀掉Oracle数据库中某个用户的所有session

#!/bin/sh

if [ $# -ne 1 ] ;
then
echo "Usage: $0 <Username>";
echo "WARNING: the <Username> MUST in upper case.";
exit 1;
fi

username=$1
echo $username

function_get_info(){
username=$1

sqlplus  / as sysdba  <<EOF
select username,sid,serial# from v\$session where username = '$username';
EXIT
EOF
}

function_get_info ${username} |awk '/^'${username}'/ { print "alter system kill session '\''"  $2 "," $3 "'\'' ; "} '
sql_killsession=`function_get_info |awk '/^'${username}'/ { print "alter system kill session  '\''"  $2 "," $3 "'\''; "} '`
echo $sql_killsession

sqlplus  / as sysdba  <<EOF
#$sql_killsession
EXIT
EOF

标签: oracle, killsession

Related posts:

1. 笔记：查询oracle被锁的对象
2. 如何使用跟踪事件10046
3. AutoTrace
4. ORACLE 10G AWR 速查
5. SHARED转为DEDICATED及ORA-12519错误