1.查询被锁定的用户 select username,account_status,lock_date from dba_users; 2.解锁 ALTER USER LGQ_KY（用户） ACCOUNT UNLOCK;
查看被锁的表: SELECT p.spid, c.object_name, b.session_id, b.oracle_username, b.os_user_name FROM v
p
r
o
c
e
s
s
p
,
v
process p, v
processp,vsession a, v$locked_object b, all_objects c WHERE p.ADDR = a.PADDR AND a.PROCESS = b.PROCESS AND c.OBJECT_ID = b.OBJECT_ID
解锁：alter system kill session ‘146’;(其中146为锁住的进程号)
