Query the locked oracle table and the process of killing the locked table

Query the oracle-locked table and the process of killing the lock table. 1. First, check that the locked table contains too many processes: SELECT substr (v $ lock. sid, 1, 4) "SID", serial #, V $ SESSION. sid, substr (username,) "UserName", substr (object_name,) "ObjectName", v $ lock. type "LockType", www.2cto.com decode (rtrim (substr (lmode, 1, 4), '2', 'row-S (SS) ', '3 ', 'row-X (SX) ', '4', 'share', '5','s/Row-X (SSX) ', '6', 'exclusive ', 'other') "LockMode", substr (v $ session. program, 25, 1) "ProgramName"
From v $ LOCK, SYS. DBA_OBJECTS, V $ SESSIONWHERE (OBJECT_ID = v $ lock. id1 AND v $ lock. sid = v $ session. sid AND username is not null and username not in ('sys ', 'system') and serial #! = 1); 2. Process for killing the lock table: www.2cto.com alter system kill session 'sid, serial #';