Terminating Sessions

Terminating Sessions

当一个会话被终止时，该会话所有的事务会被回滚，相应的资源（locks memory areas）也会立即被释放。
sql statement ：alter system kill session '7,15';
<wbr><wbr><wbr><wbr><br><br> 1.确定哪些会话需要终止<br><wbr><wbr> SELECT SID, SERIAL#, STATUS<br><wbr> FROM V$SESSION<br><wbr> WHERE USERNAME = 'JWARD';<br><br> SID<wbr><wbr><wbr> SERIAL#<wbr><wbr><wbr> STATUS<br> -----<wbr> ---------<wbr> --------<wbr><wbr><br><wbr>7<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 15<wbr><wbr><wbr><wbr> ACTIVE <wbr><br> 12<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 63<wbr><wbr><wbr><wbr> INACTIVE<br><br><br><wbr>ACTIVE<wbr><wbr> --》 making a SQL call to Oracle Database.<br> INACTIVE<wbr> --》 not making a SQL call to the database <wbr><br><br><br> 2.干掉session<br><wbr><wbr><wbr> alter system kill session '7,15';<br><br> 注意：An active session cannot be interrupted when it is performing network I/O or rolling back a transaction. Such a session cannot be terminated until the operation completes. In this case, the session holds all resources until it is terminated.<br><br><br><br> Additionally, the<br> session that issues the<wbr> ALTER SYSTEM statement to terminate a session waits up to 60 seconds for the session to be terminated. If<wbr> the operation that cannot be interrupted continues past one minute, the issuer of the<wbr> ALTER SYSTEM statement receives a message indicating that the session has been marked to be terminated. A session marked to be terminated is indicated in V$SESSION with a status of<wbr> KILLED<wbr> and a server that is something other than<wbr> PSEUDO 。<br><br><br> 3.干掉an Inactive Session<br><br> SELECT SID,SERIAL#,STATUS,SERVER<br><wbr><wbr> FROM V$SESSION<br><wbr><wbr> WHERE USERNAME = 'JWARD';<br><br> SID<wbr><wbr><wbr> SERIAL#<wbr><wbr> STATUS<wbr><wbr><wbr><wbr> SERVER<br> -----<wbr> --------<wbr> ---------<wbr> ---------<br><wbr><wbr><wbr> 7<wbr><wbr><wbr><wbr><wbr><wbr><wbr> 15<wbr> INACTIVE<wbr><wbr> DEDICATED<br><wbr><wbr> 12<wbr><wbr><wbr><wbr><wbr><wbr><wbr> 63<wbr> INACTIVE<wbr><wbr> DEDICATED<br> 2 rows selected.<br><br> ALTER SYSTEM KILL SESSION '7,15';<br> Statement processed.<br><br><br><br> 确定下session 是否已经被kill了<br><br> SELECT SID, SERIAL#, STATUS, SERVER<br><wbr><wbr> FROM V$SESSION<br><wbr><wbr> WHERE USERNAME = 'JWARD';<br><br> SID<wbr><wbr><wbr> SERIAL#<wbr><wbr> STATUS<wbr><wbr><wbr><wbr> SERVER<br> -----<wbr> --------<wbr> ---------<wbr> ---------<br><wbr><wbr><wbr> 7<wbr><wbr><wbr><wbr><wbr><wbr><wbr> 15<wbr> KILLED<wbr><wbr><wbr><wbr> PSEUDO<br><wbr><wbr> 12<wbr><wbr><wbr><wbr><wbr><wbr><wbr> 63<wbr> INACTIVE<wbr><wbr> DEDICATED<br> 2 rows selected.<br><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>