清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | #!/bin/sh function _oracleplus(){ su - oracle -c "$oraclehome/bin/sqlplus /nolog" & lt ;& lt ;EOF connect / as sysdba; $1 exit EOF } echo "start select $1 session!!!" selectUS= "select 'alter system kill session '''||sid||','||serial#||''';' from v\$session where username=''$1'';" _oracleplus "$selectUS" | grep 'alter system' & gt ; onlinesession.dmp echo "start kill $1 session!!!" cat onlinesession.dmp | while read line; do _oracleplus "$line" done echo "end kill $1 session!!!" |