Eric Guo's blog.cloud-mes.com

Hoping writing JS, Ruby & Rails and Go article, but fallback to DevOps note

Unlock the Locked Table by Kill Session

• Permalink

Seems I frequently need to kill some session due to the network issue or other client issue to submit data to oracle, but each time I google the answner, it takes me at least 5 minutes, so I decide to write done SQL and command here:

Find the locked session
SELECT a.sid,a.serial#, a.username,c.os_user_name,a.terminal,

b.object_id,substr(b.object_name,1,40) object_name

from v$session a, dba_objects b, v$locked_object c

where a.sid = c.session_id

and b.object_id = c.object_id
Kill session
alter system kill session '14,397';

Comments