Oracle查看表是否被锁||解锁

1.查看被锁的表
SELECT 
    a.OS_USER_NAME,b.sid,b.serial#,c.owner,c.object_name,logon_time 
FROM 
    v$locked_object a, v$session b, dba_objects c
WHERE 
    a.session_id = b.sid
AND a.object_id = c.object_id
ORDER BY  b.logon_time;
2.解锁
ALTER system kill SESSION 'SID,SERIAL#';