KILL_SESSION
接口/方法功能
终止指定会话连接。
接口/方法声明
PROCEDURE KILL_SESSION(NODEID INTEGER,SESSID INTEGER);参数说明
| 参数名称 | 参数类型 | 参数解释 | 默认值 |
|---|---|---|---|
| NODEID | INTEGER | 节点号 | 无 |
| SESSID | INTEGER | 会话号 | 无 |
操作示例
SQL> SELECT nodeid,session_id,ip,user_name,db_name,start_t,status,curr_tid,auto_commit,trans_start_t FROM sys_sessions;
NODEID | SESSION_ID | IP | USER_NAME | DB_NAME | START_T | STATUS | CURR_TID | AUTO_COMMIT | TRANS_START_T |
------------------------------------------------------------------------------
1 | 230493 | 127.0.0.1| SYSDBA| SYSTEM| 2015-05-13 17:26:52.000 AD | 114 | 717724 | T | 2022-05-13 17:48:48.000 AD |
1 | 230494 | 127.0.0.1| SYSDBA| SYSTEM| 2015-05-13 17:44:29.000 AD | 112 | 717719 | F | 2022-05-13 17:45:35.000 AD |
1 | 230495 | 127.0.0.1| SYSDBA| SYSTEM| 2015-05-13 17:44:47.000 AD | 112 | <NULL>| F | <NULL>|
Total 3 records.
Use time:0 ms.
SQL> EXEC DBMS_DBA.KILL_SESSION(1,230495);