ALTER SYSTEM KILL SESSION

Updated on 2024-09-30 GMT+08:00

View PDF

Function

ALTER SYSTEM KILL SESSION ends a session.

Precautions

None

Syntax

    
       ALTER SYSTEM KILL SESSION 'session_sid, serial' [ IMMEDIATE ];

Parameter Description

session_sid, serial
Specifies SID and SERIAL of a session (see examples for format).

Value range: The SIDs and SERIALs of all sessions that can be queried from the system catalog V$SESSION.
IMMEDIATE
Indicates that a session will be ended instantly after the command is executed.

Examples

Query session information.

    
       SELECT sid,serial#,username FROM V$SESSION;

       sid       | serial# | username 
-----------------+---------+----------
 140131075880720 |       0 | 
 140131025549072 |       0 | 
 140131073779472 |       0 | 
 140131071678224 |       0 | 
 140131125774096 |       0 | 
 140131127875344 |       0 | 
 140131113629456 |       0 | 
 140131094742800 |       0 | 
(8 rows)

End the session whose SID is 140131075880720.

    
       ALTER SYSTEM KILL SESSION '140131075880720,0' IMMEDIATE;

Parent topic: DDL Syntax

Previous topic: ALTER SYNONYM

Next topic: ALTER TABLE

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel