Resolve Oracle Database Ora-00054:resource busy and acquire with NOWAIT specified error

Resolve Oracle Database Ora-00054:resource busy and acquire with NOWAIT specified error

When I use the PL/SQL Developer client call stored procedure to find a halfway card machine and then force termination of PL/SQL developer, Oracle has been locked out of the lock-related error.
It was analyzed that a pessimistic blockade was caused when a DDL statement was manipulated on a table when the stored procedure was called. After the client card machine, Oracle has not released the lock and has never completed the release resulting in an error.

This session needs to be forced to kill:
1. Querying objects that are currently locked

Select T2.username, T2.sid, t2.serial#, T2.logon_time        from v$locked_object T1, v$session T2      where = T2.sid      Order  by T2.logon_time

2. Query session Information
Sql> Select v.sid,v.serial#,v.username,v.action from V$session v WHERE v.sid in (SELECT session_id from V$locked_object WHERE oracle_username= ' ATHENA ') and v.machine= ' nbcb\kjb-080701n ';

3. Kill a Conversation
Grammar:
ALTER SYSTEM KILL SESSION ' sid,serial# ';
For example:
ALTER SYSTEM KILL SESSION ' 436,62365 ';

After killing the query, found that the SID corresponding data is gone, so you can! Not really. Only restart the database

Resolve Oracle Database Ora-00054:resource busy and acquire with NOWAIT specified error