Skip to content

Instantly share code, notes, and snippets.

@mbreslow
Last active September 20, 2017 20:36
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mbreslow/5301933 to your computer and use it in GitHub Desktop.
Save mbreslow/5301933 to your computer and use it in GitHub Desktop.
Get a list of sessions in Oracle RDS + command to kill session
SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
S.Username,
S.Program,
'exec rdsadmin.rdsadmin_util.kill('||s.sid||','||s.serial#||');'
FROM gv$session s
Join Gv$process P On P.Addr = S.Paddr And P.Inst_Id = S.Inst_Id
Where S.Type != 'BACKGROUND'
AND s.username = '&myUpperCaseSensitiveUsername';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment