How To Kill A Session In Oracle Database - DBACLASS

The syntax to kill a session in oracle database is :

ALTER SYSTEM KILL SESSION ‘SID,SERIAL#’ IMMEDIATE;

EXAMPLE:

First get the sid and serial# of the session;

Here the session is executing the query SELECT * FROM DBACLASS;

Use the below query to get the sid and serial# of this sql query.

 COL SQL_TEXT format a45 SQL> SELECT a.sid,a.serial#,substr(b.sql_text,1,200) sql_text from v$sql b, v$session a where a.sql_id=b.sql_id and upper(b.sql_text) like '%DBACLASS%' and upper(b.sql_text) not like '%V$SQL%'; 2 SID SERIAL# SQL_TEXT ---------- ---------- --------------------------------------------- 24 19329 select * from dbaclass ----Now kill session : SQL> alter system kill session '24,19329' immediate; System altered.    

About Admin

View all posts by Admin →

Related Articles

• How to change asm spfile location in oracle RAC
• How to add a node in oracle RAC 19c
• How to modify scan name in oracle RAC
• How to apply JDK patch in oracle database
• How to change private interconnect details in oracle grid
• How to encrypt a table using dbm_redef with zero down time
• How to setup password less ssh connectivity using sshUserSetup.sh
• How to multiplex control file in standalone database

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed. Custom Search

• 5ansible
• 48BACKUP & RECOVERY
• 6BLOG
• 16CLOUD
• 59DATABASE
• 40DATABASE SCRIPTS
• 10Database-Wiki
• 28DATAGUARD
• 9DB TOOLS
• 18GOLDENGATE
• 3HADOOP
• 47HOW TO
• 11INTERVIEW QA
• 61ORACLE 12C
• 5ORACLE 18C
• 12ORACLE 19C
• 59ORACLE RAC
• 13ORACLE SECURITY
• 30PERFORMANCE TUNING
• 29POSTGRES
• 4R-STUDIO
• 13SHELL SCRIPT
• 152TROUBLESHOOTING
• 3WEBLOGIC

• Upgrade database from 11g to 12c manually 114268 16
• Upgrade database from 12.1.0.2 to 12.2.0.1 86449 9
• ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT 85494 3
• Prerequisite check “CheckActiveFilesAndExecutables” failed 74483 3
• install oracle goldengate 12c on linux 7 67894 0
• How to run SQL tuning advisor for a sql_id 66021 9
• Transparent Data Encryption (TDE) in oracle 12c 55909 2
• How to drop and recreate temp tablespace in oracle 55865 8
• ORA-01624: log 1 needed for crash recovery of instance 55372 2
• Restoring archivelogs from RMAN tape backup 52061 0

Tags

12c 19C archive archivelog ASM Audit AWR backup cloning cloud cluster database dataguard dgmgrl DISKGROUP EDB EXPDP failover flashback goldengate grid impdp multitenant OPATCH ORA- oracle oracle 12.2. oracle 12c partition patch patching PDB pluggable postgres RAC replication rman SCRIPT security SHELL script standby tablespace temp undo upgrade