Sql

Search

oracle kill session by username

-- Get ORACLE Session IDs (SID and SERIAL#)
SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>';
-- Kill session (and wait for rollback if any...)
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql query to get column data type in sql
Sql :: sql server version query
Sql :: liquibase alter column type / length
Sql :: sql add days to date
Sql :: sql first day of current year
Sql :: sql script get all stored procedures from database
Sql :: oracle list functions
Sql :: RENAME table pl sql
Sql :: how to start mysql
Sql :: oracle search code in packages
Sql :: sql drop schema
Sql :: rename column postgres
Sql :: sql error 1175
Sql :: not today mysql
Sql :: alter default column value oracle
Sql :: how to show all users in mysql
Sql :: how to get last row of table in sql
Sql :: mysql take number in string
Sql :: sql drop primary key
Sql :: postgres extract number from string
Sql :: mysql created at yesterdau
Sql :: SELECT User,Host FROM mysql.user;
Sql :: hibernate dialect property xml for mysql 8
Sql :: jooq convert using gbk
Sql :: psql autocomplete for mac brew install
Sql :: Mysql Workbench takes very long time to execute the first query
Sql :: create procedure with encryption
Sql :: duplicate column values sql
Sql :: mysql user permission database
Sql :: operadores en postgresql

Search

SQL

oracle kill session by username

ADD CONTENT