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


414 views

Recent Posts

See All

Oracle Optimizer determines the cost of each execution plan based on database, schema, table and other statistics. The changes inside database result in stale statistics. As a DBA, you must gather sta

Imagine an application user gave accidental salary hike of 50% instead of 5% to all employees! To initiate a database point-in-time recovery, we must know the exact time the query was executed against