DECLARE

   u_sid  varchar2(50);

   u_serialnumber varchar2(50);

   u_name varchar2(50);

   CURSOR c1 IS select trim(s.sid),trim(s.serial#)

                              from v$session s,v$process p

                              where s.paddr = p.addr  and (s.username=u_name); 

BEGIN

   -- 替换用户名，必须大写

    u_name:='SM9DEV';

   OPEN c1; 

   LOOP

      FETCH c1 INTO u_sid,u_serialnumber;

      EXIT WHEN c1%NOTFOUND;

      EXECUTE IMMEDIATE 'alter system kill session '||''''||trim(u_sid)||','||trim(u_serialnumber)||'''';

   END LOOP;

END;

drop user sm9dev cascade;

create user sm9dev identified by oradev default tablespace sm9db Temporary TABLESPACE Temp;

-- 授权

grant connect,resource,dba to sm9dev;

-- 下面的语句查看所有用户的连接信息

select s.username,s.osuser,s.program,s.MACHINE, s.sid, s.serial#, p.spid,

       'alter system kill session '||''''||trim(s.sid)||','||trim(s.serial#)||''';'

from v$session s,v$process p

where s.paddr = p.addr   and s.username is not null;