Answers for "Kill all session in Oracle"

SQL
6

oracle kill session

-- 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;
Posted by: Guest on April-21-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language