• Arun Kumar

Kill Session Oracle

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';


563 views

Recent Posts

See All

Oracle database refresh is the most common activity in any environment. There are multiple ways to perform the database refresh. Here you will find most common methods that are used for refresh activi