oracle锁定用户和锁表
1.oracle解锁用户:ALTER USER 用户名 ACCOUNT UNLOCK;
2.oracle锁表
查询被锁的表:
SELECT
p.spid,
a.serial #,
c.object_name,
b.session_id,
b.oracle_username,
b.os_user_name
FROM
v$process p,
v$session 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;
查看是哪个session引起的:
alter system kill session 'sid,serial#';(其中sid=l.session_id)