• Arun Kumar

Kill Session Oracle

Sometimes you might need to kill a session inside Oracle database. Before you kill, make sure you have permission from 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';



168 views

Recent Posts

See All

Reclaim Unused Space in Oracle

Over a period of time, updates and deletes on objects within a tablespace can create pockets of empty space that individually are not large enough to be reused for new data. This type of empty space i