<
>

kill oracle session without gui  [ 768 views ]

Goal: a simple way to kill a session in Oracle

If we know the SID of the session to be killed, then use the following select to create the immediate command:

select 'alter system kill session '''|| s.sid|| ','|| s.serial#|| ''' immediate;'
  from v$session s
 where sid in (...)

Friday, August 7th, 2015 at 13:59.
Filed under oracle.

#sidebar a { color:#fff; } #sidebar ul ul li { color: #DEF585; } #sidebar h2 { color: #fff; } #sidebar ul p, #sidebar ul select { color: #BEDDBE; } #backfly { background: url(images/golfBallWallPaper.jpg) left bottom fixed repeat-x #65a51d; }