Database query lock table and SQL to unlock table

Before the operation of the program, the sudden occurrence of the page card dead, the background does not error, after troubleshooting is the database table is locked dead, the following SQL is the query is locked table, as well as the corresponding unlock SQL;

Select B.owner,b.object_name,a.session_id,a.locked_mode from V$locked_object a,dba_objects b where b.object_id = a.object_id;

Select B.username,b.sid,b.serial#,logon_time from V$locked_object a,v$session b where a.session_id = B.sid ORDER by B.logo N_time;

Alter system kill session ' 300,37803 ';

SELECT S.sid, s.serial#, S.username, S.schemaname, S.osuser, s.process, S.machine,

S.terminal, S.logon_time, L.type

From V$session S, V$lock l

WHERE S.sid = L.sid

And S.username is not NULL

ORDER by Sid;

Database query lock table and SQL to unlock table