Dadabasha Pesarai
Tuesday, March 18, 2014
How to Kill the Session in Oracle
SELECT SID, SERIAL#, STATUS FROM V$SESSION
----------------------------------------------
1 17 INACTIVE
5 566 INACTIVE
9 55 ACTIVE
ALTER SYSTEM KILL SESSION 'sid,serial#'
ALTER SYSTEM KILL SESSION '1,17'
/
ALTER SYSTEM KILL SESSION '5,566'
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment