Query and unlock Oracle locks

1 ).

-- Query locks
Select LOCK_INFO.OWNER | '.' | LOCK_INFO.OBJ_NAME as "existing object name already", -- object name already (already pinned)
LOCK_INFO.SUBOBJ_NAME as "subitem name already exists", -- subitem name already exists (already pinned)
SESS_INFO.MACHINE as "" ", --
LOCK_INFO.SESSION_ID as "session ID", -- session SESSION_ID
SESS_INFO.SERIAL # as "session SERIAL #", -- session SERIAL #
SESS_INFO.SPID as "OS system SPID", -- OS system SPID
(SELECT INSTANCE_NAME from v $ INSTANCE) "INSTANCE name SID", -- INSTANCE name SID
LOCK_INFO.ORA_USERNAME as "ORACLE users", -- region name for ORACLE Systems
LOCK_INFO. OS _USERNAME as "OS user", -- guest name used for operating systems
LOCK_INFO.PROCESS as "progress parameter", -- Progress Parameter
LOCK_INFO.OBJ_ID as "Object ID", -- Object ID
LOCK_INFO.OBJ_TYPE as "Object Type", -- Object Type
SESS_INFO.LOGON_TIME as "login time", -- login time
SESS_INFO.PROGRAM as "program name example", -- program name example
SESS_INFO.STATUS as "when", -- when "when"
SESS_INFO.LOCKWAIT as "waiting for renewal", -- waiting for renewal
SESS_INFO.ACTION as "action", -- Action
SESS_INFO.CLIENT_INFO as "customer information" -- customer information
From (select obj. owner as owner,
OBJ. object_name as obj_name,
OBJ. subobject_name as subobj_name,
OBJ. object_id as obj_id,
OBJ. object_type as obj_type,
Lock_obj.SESSION_ID as SESSION_ID,
Lock_obj.ORACLE_USERNAME as ORA_USERNAME,
Lock_obj. OS _USER_NAME as OS _USERNAME,
Lock_obj.PROCESS as PROCESS
From (select *
From all_objects
Where object_id in (select object_id from v $ locked_object) obj,
V $ locked_object lock_obj
Where obj. object_id = lock_obj.object_id) LOCK_INFO,
(Select SID,
SERIAL #,
LOCKWAIT,
STATUS,
(Select spid from v $ process where addr = a. paddr) spid,
Program,
Action,
Client_info,
Logon_time,
Machine
From v $ session a) sess_info
Where lock_info.session_id = sess_info.sid
Order by lock_info.session_id;

2 ).
Select SQL _text
From v $ sqltext
Where address in (select SQL _address from V $ session where Sid = & SID)
Order by piece;
3 ).
Alter system kill session 'session ID, session serial # '; -- Unlock

 

This article from the csdn blog, reproduced please indicate the source: http://blog.csdn.net/wizardlun/archive/2010/03/30/5432058.aspx