Skip to content

Instantly share code, notes, and snippets.

@snickerjp

snickerjp/Oracleセッション管理

Created February 8, 2012 12:09
Show Gist options
  • Save snickerjp/1768581 to your computer and use it in GitHub Desktop.
Save snickerjp/1768581 to your computer and use it in GitHub Desktop.
Download ZIP
Management Oracle Session
Raw
Oracleセッション管理
select SID,SERIAL#,USERNAME,MODULE,OSUSER,PROGRAM,MACHINE from v$session where OSUSER = 'ユーザ名';
Raw
セッション切断
alter system kill session 'SID,SERIAL#';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment