Oracle Action Table "Resource is busy, need to specify nowait" method of unlocking

Oracle Action Table "Resource is busy, need to specify nowait" method of unlocking

Problem:

When executing drop table table_name, the prompt "resource is busy, you need to specify NoWait"
PL/SQL is not responding due to a problem that can only be queried for setting the primary key and cannot be modified and deleted, so the table is locked for tb_project

Analysis:

Indicates that the TABLE_NAME table is locked by a user action and must be unlocked before proceeding

Solve:

1> This statement to query the session_id that is being locked:

SELECT session_id from V$locked_object,user_objects WHERE v$locked_object. object_id = user_objects. object_id

2> through the first step query to the session_id query serial#

SELECT serial# from v$session WHERE sid= ' session_id ' (here is the ' session_id ' queried above)

3> based on 1, 2 step query to SESSION_ID and serial# execute alter SYSTEM KILL SESSION ' 48,2476 ' (48 is session_id value, 2476 is serial# value)

Oracle Action Table "Resource is busy, need to specify nowait" method of unlocking