for x in $sessions
do
echo "alter system kill session '${x#\#}';" | sqlplus -S "/ as sysdba"
done
----------------------------------------------------------------------------------
CREATE PROCEDURE KILL_USER(as_username VARCHAR2)
AS
s_sid varchar2(8);
s_serial varchar2(16);
s_cs varchar2(40);
BEGIN
select sid,serial into s_sid ,s_serial from v$session
where username = as_username ;
s_cs := sid || ',' || serial
alter system kill session s_cs ;
CREATE PROCEDURE KILL_USER(as_username VARCHAR2)
AS
s_sid varchar2(8);
s_serial varchar2(16);
s_cs varchar2(40);
BEGIN
select sid,serial into s_sid ,s_serial from v$session
where username = as_username ;
s_cs := sid || ',' || serial
alter system kill session s_cs ;