Kill Oracle Online User script sharing _linux Shell

Kill Oracle Online users and use root to execute this script on Oracle's server
Parameter description for this Oracle user

Copy Code code as follows:

#!/bin/sh
function _oracleplus () {
Su-oracle-c "$oraclehome/bin/sqlplus/nolog" <<eof
Connect/as Sysdba;
$
Exit
Eof
}
echo "START select Session!!!"
selectus= "SELECT ' Alter system kill session '" ' | | sid| | ', ' | | serial#| | ' from V\ $session where username= '; '
_oracleplus "$selectUS" |grep ' alter system ' > ONLINESESSION.DMP
echo "Start kill session!!!"
Cat Onlinesession.dmp | while read line;
Todo
_oracleplus "$line"
Done
echo ' END Kill ' session!!!