oracle 查询锁表、用户锁定、解锁

1.查询哪些对象被锁：

select object_name,machine,s.sid,s.serial#

from v$locked_object l,dba_objects o ,v$session s

where l.object_id = o.object_id and l.session_id=s.sid;

2.解锁对象：

(其中100,266分别是上面查询出的sid,serial#)

alter system kill session '100,266'; 

3.查询用户是否锁定

 select username,account_status,lock_date from dba_users ;

4.解锁用户

 ALTER USER username ACCOUNT UNLOCK;