alter system disconnect/kill session 'sid,serial#';
alter system disconnect 'sid,serial#';
1.session 1
SQL> conn yxy
Enter password:
Connected.
SQL> select * from t;
NUM
----------
1
SQL> update t set num=2 where num=1;
1 row updated.
2.session 2
SQL> select sid,serial#,username from v$session where type='USER';
SID SERIAL# USERNAME
---------- ---------- ------------------------------
10 1
11 1
15 21625 SYS
20 9893 YXY
SQL> select a.sid,a.serial#,a.username,b.spid from v$session a,v$process b where a.paddr=b.addr and a.sid=20;
SID SERIAL# USERNAME SPID
---------- ---------- ------------------------------ ------------
20 9907 YXY 27596
SQL> alter system disconnect session '20,9907' immediate;
System altered.
SQL> host
[oracle@restore ~]$ ps -ef | grep 27596
oracle 27596 27594 0 20:01:30 ? 0:00 oracleoramdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 27693 27690 0 20:06:38 pts/ta 0:00 grep 27596
3.session 1
SQL> r
1* update t set num=2 where num=1
update t set num=2 where num=1
*
ERROR at line 1:
ORA-00028: your session has been killed
SQL> exit
[oracle@restore ~]$
4.session 2
[oracle@restore ~]$ ps -ef | grep 27596
oracle 27697 27690 0 20:06:47 pts/ta 0:00 grep 27596
[oracle@restore ~]$ ps -ef | grep 27596
[oracle@restore ~]$ ps -ef | grep 27596
oracle 27771 27690 1 20:06:51 pts/ta 0:00 grep 27596
alter system kill session 'sid,serial#';
1.session 1
SQL> update t set num=2 where num=1;
1 row updated.
2.session 2
SQL> select a.sid,a.serial#,a.username,b.spid from v$session a,v$process b where a.paddr=b.addr and a.sid=20;
SID SERIAL# USERNAME SPID
---------- ---------- ------------------------------ ------------
20 9939 YXY 27887
SQL> alter system kill session '20,9939' immediate;
System altered.
SQL> host
[oracle@restore ~]$ ps -ef | grep 27887
oracle 27974 27972 0 20:19:13 pts/ta 0:00 grep 27887
oracle 27887 27871 0 20:15:54 ? 0:00 oracleoramdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[oracle@restore ~]$ ps -ef | grep 27887
oracle 27887 27871 0 20:15:54 ? 0:00 oracleoramdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 27976 27972 0 20:19:24 pts/ta 0:00 grep 27887
2.session 1
SQL> r
1* update t set num=2 where num=1
update t set num=2 where num=1
*
ERROR at line 1:
ORA-00028: your session has been killed
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
[oracle@restore ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.5.0 - Production on Sat Mar 17 20:20:02 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn yxy
Enter password:
Connected.
SQL> select * from t;
NUM
----------
1
3.session 2
[oracle@restore ~]$ ps -ef | grep 27887
oracle 27979 27972 0 20:19:41 pts/ta 0:00 grep 27887
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7364032/viewspace-17458/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ora-00054 , alter system kill session 'id,serial#'Session
- ALTER SYSTEM DISCONNECT SESSION ClauseSession
- alter system kill sessionSession
- alter system kill session 不成功Session
- Alter system kill session and ORA-00031: session marked for killSession
- ALTER SYSTEM KILL SESSION這麼沒力?(轉)Session
- disconnect session和kill session的區別Session
- "alter system kill session" can crash the instance if IO slaves usedSession
- disconnect session和kill session的區別 轉Session
- To display Locks and give the SID and Serial# of the Session to Kill_1020007.6Session
- 獲取本session的sid和serial#Session
- 檢視鎖的資訊和alter system kill session的用法(小例子)Session
- alter session|system set eventsSession
- v$session檢視中的sid和serial#研究Session
- alter database和alter system和alter session的區別DatabaseSession
- [20180918]disconnect session和kill session的區別.txtSession
- 【故障-ORACLE】‘ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID=’解釋Oracle
- kill sessionSession
- alter system events與alter system event的區別
- 【kill session】Oracle 徹底 kill session(轉載)SessionOracle
- Alter system in OracleOracle
- [alter system dump學習1]alter system dump logfile
- alter system archive log current和alter system switch logfileHive
- awk -- kill sessionSession
- Oracle kill sessionOracleSession
- alter session setSession
- ALTER SYSTEM SWITCH LOGFILE ALTER SYSTEM ARCHIVELOG CURRENT 區別Hive
- alter system enable restricted session 及 startup restrict 限制使用者登入RESTSession
- mysql批次kill sessionMySqlSession
- Oracle kill session scriptOracleSession
- oracle_kill_sessionOracleSession
- KILL SESSION 相關Session
- Oracle中Kill sessionOracleSession
- Oracle批量kill sessionOracleSession
- alter system switch logfile和alter system archive log current的區別Hive
- alter system switch logfile 和 alter system archive log current 的區別Hive
- ALTER SESSION SET EVENTSSession
- alter system check datafiles 命令