为了做这个实验我先创建一个用户,用户名:cuijie 密码为:huyoung
SQL> create user cuijie identified by huyoung;
SQL> create user cuijie identified by huyoung;
User created.
SQL> grant connect to cuijie;
Grant succeeded.
在客户端链接测试一下
$ sqlplus cuijie/huyoung
SQL> select sysdate from dual;
$ sqlplus cuijie/huyoung
SQL> select sysdate from dual;
SYSDATE
---------
27-JUL-10
---------
27-JUL-10
现在已经有一个客户端链接到数据库中了(用户为cuijie),下面我们在数据库里面查询一下这个用户。这里我们就需要
v$session这个视图了。
SQL> select sid,serial#,username from v$session;
SQL> select sid,serial#,username from v$session;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
118 1394 CUIJIE
---------- ---------- ------------------------------
118 1394 CUIJIE
SQL> alter system kill session '118,1394';
SQL> select sysdate from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-00028: your session has been killed
select sysdate from dual
*
ERROR at line 1:
ORA-00028: your session has been killed
这样就把远端用户cuijie给剔除出去了。
转载于:https://blog.51cto.com/huyoung/360878