Kill Session Oracle

Safely terminate sessions in Oracle to resolve blocking issues.

Sometimes you might need to kill a session inside the Oracle database. Before you kill, make sure you have permission from the application team to proceed.

Syntax

Below is the syntax to kill a session inside Oracle database

ALTER SYSTEM KILL SESSION 'SID,Serial#';

Example

ALTER SYSTEM KILL SESSION '38,6453';