자바, 스프링, JPA, C#, WPF, Xamarin, SQL, DB, Angular, AI, Block Chain을 사랑하는 풀스택개발자(mylife68@nate.com): 오라클 세션 kill,User Session Kill[오라클개발자교육/오라클/ORACLE강좌/오라클교육잘하는곳/오라클교육추천/ORACLE실무교육/ORACLE/ORACLE교육/ORACLE학원/오라클실무교육] REM UserKill.sql REM REM col C1 for A10 head UserID set verify off prompt Enter a username (return=all) select SID,serial#,SID||','||serial# C1,username,status from v$session where username like upper('&username%') / prompt Now kill the user: (return = kill no users) alter system kill session '&UserID' / select SID,serial#,username,status from v$session where username = upper('&username') / undefine username [실행 예] ---------------------- Session 1 (scott/tiger로 접속) ---------------------- SQL>conn scott/tiger SQL> ---------------------- Session 2 (sys user로 접속) ---------------------- SQL> @UserKill Enter a username (return=all) Enter value for username: scott SID SERIAL# UserID USERNAME STATUS ---------- ---------- ---------- ------------------------------ -------- 12 4 12,4 SCOTT INACTIVE Now kill the user: (return = kill no users) Enter value for userid: 12,4 System altered. Enter value for username: -------------------------- Session 1 -------------------------- SQL> select * from tab; select * from tab * ERROR at line 1: ORA-00028: your session has been killed [출처] 오라클자바커뮤니티 - http://www.oraclejavanew.kr/bbs/board.php?bo_table=oracleTip&wr_id=719 오라클자바커뮤니티에서 운영, 개발자 전문교육, 개인80%환급 오엔제이프로그래밍실무교육센터(www.onjprogramming.co.kr) 평일주간(9:30~18:30) 개강 (4/14)[기업100%환급]Spring ,MyBatis,Hibernate실무과정 (4/14)[기업100%환급]PL/SQL,ORACLE HINT,TUNING (4/14)C#4.0,ADO.NET,Network 프로그래밍 (4/21)[기업100%환급]SQL기초에서 Schema Object까지 (4/21)[기업100%환급]자바기초에서 JDBC, Servlet/JSP까지 평일야간(19:00~22:00) 개강 (4/10)C#,ASP.NET마스터 (4/10)SQL초보에서실전전문가까지 (4/10)자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지 (4/14)웹퍼블리싱 마스터 (4/15)Spring3.X, MyBatis, Hibernate실무과정 (4/22)안드로이드개발자과정 주말(10:00~18:00) 개강 (4/12)웹퍼블리싱 마스터 (4/12)SQL초보에서실전전문가까지 (4/12)닷넷실무자를위한WPF개발자과정 (4/19)C#,ASP.NET마스터 (5/03)자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지 (5/03)Spring3.X, MyBatis, Hibernate실무과정 (5/03)안드로이드개발자과정

2014년 4월 8일 화요일

오라클 세션 kill,User Session Kill[오라클개발자교육/오라클/ORACLE강좌/오라클교육잘하는곳/오라클교육추천/ORACLE실무교육/ORACLE/ORACLE교육/ORACLE학원/오라클실무교육]

REM UserKill.sql

REM

col C1 for A10 head UserID

set verify off

prompt Enter a username (return=all)

select SID,serial#,SID||','||serial# C1,username,status

from   v$session

where  username like upper('&username%')

prompt Now kill the user: (return = kill no users)

alter system kill session '&UserID'

select SID,serial#,username,status

from   v$session

where  username = upper('&username')

undefine username

[실행 예]

----------------------

Session 1 (scott/tiger로 접속)

----------------------

SQL>conn scott/tiger

SQL>

----------------------

Session 2 (sys user로 접속)

----------------------

SQL> @UserKill

Enter a username (return=all)

Enter value for username: scott

SID SERIAL# UserID USERNAME STATUS

---------- ---------- ---------- ------------------------------ --------

12 4 12,4 SCOTT INACTIVE

Now kill the user: (return = kill no users)

Enter value for userid: 12,4

System altered.

Enter value for username:

--------------------------

Session 1

--------------------------

SQL> select * from tab;

select * from tab

ERROR at line 1:

ORA-00028: your session has been killed

2014년 4월 8일 화요일