A small problem with Oracle unlocked table

Recently developed a small problem encountered, after executing a section of SQL found that the table is locked

Display error: Ora-00054:resource busy and acquire with nowait specified

Baidu later found that the session process stuck, it can be said that some resources of the table is locked

The following methods can be used to unlock:

Select T2.username,t2.sid,t2.serial#,t2.logon_time
From V$locked_object t1,v$session T2
where T1.session_id=t2.sid order by T2.logon_time;

Can query for locked users and SIDS and serial

Use the following SQL to query the locked SQL

Select Sql_text from v$session a,v$sqltext_with_newlines b
where DECODE (a.sql_hash_value, 0, Prev_hash_value, sql_hash_value) =b.hash_value
and a.sid=&sid order by piece;

In the pop-up box, write Sid.

Finally, the following statement can kill the session Ching

Alter system kill session ' sid,serial# ';

such as alter system kill session ' 343,23200 ';

Resources can then be used normally ...

@ink

A small problem with Oracle unlocked table