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



122 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir