DB

Oracle Session Kill

Lawmin 2010. 11. 30. 16:28
alter system kill session '#sid, serial#' IMMEDIATE

프로세스 찾아 죽일때
select   spid  from  v$process where addr = (select paddr from v$session where sid = '#sid');

select  * from v$session where schemaname='계정'