在运维任何数据库时候，都需要及时的处理锁表问题，以下是K-DB相关的SQL语句。
可以设定定时JOB，根据执行时间长短及时反馈给相关人员进行处理。
查询：
SELECT s.sess_id "Sid"
,s.serial_no "Serial#"
,s.status "Status"
,s.user_name "DBUser"
,s.ipaddr "DBIP"
,s.machine "HostName"
,s.osuser "OSUser"
,s.prog_name "Program"
,o.owner|| '.' ||o.object_name "Object"
,FLOOR((sysdate - vt.start_time)*24) || ':'||
LPAD(FLOOR(MOD((sysdate - vt.start_time)*1440, 60)),2,0) ||':'||
LPAD(FLOOR(MOD((sysdate - vt.start_time)*86400,60)),2,0) AS "Lock_time"
,DECODE(lmode, 0, '[0]', 1, '[1]Row-S(RS)', 2, '[2]Row-X(RX)', 3, '[3]Shared(S)', 4, '[4]S/Row-S(SRX)', 5, '[5]Exclusive(X)', 6, '[6]PIN', TO_CHAR (lmode) ) "Lock mode"
,NVL(s.sql_id, s.prev_sql_id) "SQL_ID"
FROM vt_wlock l,
vt_session s,
dba_objects o,
vt_transaction vt
WHERE l.type='WLOCK_DML'
AND l.sess_id = s.vtr_tid
AND l.id1 = o.object_id (+)
AND l.sess_id = vt.sess_id order by "Lock_time" DESC;
中断：
alter system kill session 'sid,serial#'; （同ORACLE)
