Oracle DBA - How To Find And Kill Sessions - RazorSQL

Home » How To Kill Session In Oracle » Oracle DBA - How To Find And Kill Sessions - RazorSQL

Maybe your like

RazorSQL

Query, Edit, Browse, and Manage Databases

  • Home
  • Download
  • Features
  • Purchase
  • Screen Shots/Videos
  • Support
  • Contact
Finding and Killing Sessions in Oracle

To be able to find and kill sessions in an Oracle database, the user must first be logged in with DBA privileges to gain access to the tables necessary to find the sessions and the command necessary to kill the session. To connect to Oracle with DBA privileges using RazorSQL, make sure to select the "SYSDBA" connect as option when creating the Oracle connection profile on the Connections -> Add Connection Profile menu option.

After connecting with DBA privileges, the following query can be used to find the running sessions:

SELECT * FROM SYS.v_$session s, SYS.v_$sess_io io, SYS.v_$process p WHERE s.sid=io.sid AND s.paddr = p.addr

The key columns to look at in the above query are the SID, SERIAL#, and USERNAME columns. After finding the session from the query results after executing the above query, the SID and SERIAL# are needed to be able to kill the session. To kill the session, execute the following command passing in the SID and SERIAL# of the session you want to kill. Below is an example query to kill a session. The SID is the first value and the SERIAL# is the second value.

ALTER SYSTEM KILL SESSION '52,3333'

Sessions can also be disconnected using the following command that also takes the SID and SERIAL#:

ALTER SYSTEM DISCONNECT SESSION '52,3333' POST_TRANSACTION Download RazorSQL
  • Windows Download
  • macOS / Mac OS X Download
  • Linux / Unix Download
RazorSQL DBMS Support

Enhanced Features

  • Access
  • BigQuery
  • Cassandra
  • DB2
  • Derby
  • Druid
  • DynamoDB
  • Firebird
  • FrontBase
  • H2
  • Hive
  • HSQLDB
  • Informix
  • Ingres
  • Interbase
  • JavaDB
  • kdb+
  • MariaDB
  • MySQL
  • OpenBase
  • Oracle
  • Pervasive
  • PostgreSQL
  • Salesforce
  • SimpleDB
  • Snowflake
  • SQL Azure
  • SQL Server
  • SQLite
  • Sybase ASE
  • Sybase IQ
  • SQL Anywhere
  • Teradata
  • Vertica
  • VoltDB

Standard Features

  • JDBC
  • ODBC
  • Access
  • Cache (InterSystems)
  • Daffodil DB
  • DBASE
  • Greenplum
  • Mckoi
  • Mimer SQL
  • Netezza
  • Paradox
  • Pointbase
  • solidDB
© 2025 Richardson Software, LLC | Privacy | Design: styleshout | Home Feed

Tag » How To Kill Session In Oracle