top of page
  • Writer's pictureArun 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';


869 views

Recent Posts

See All

With ASM configured for RAC or NON-RAC systems, it is a good idea to move the spfile to ASM. The PFILE under $ORACLE_HOME/dbs location actually points to the SPFILE on ASM disk. Create PFILE from SPFI

bottom of page