Want to modify a table under Oracle, prompt

“Resource busy, NOWAIT or expired”

Looks like it’s locked.

Log in to the database as a system administrator, and

SELECT sid, serial#, username, osuser FROM v$session where sid 
in(select session_id from v$locked_object);
-- Kill the related session
ALTER SYSTEM KILL SESSION '597117';--sid,serial#
Copy the code

Article saying that sometimes resources release are fast enough, and some other way: www.eygle.com/archives/20…