User receiving ORA-00054: resource busy and acquire with NOWAIT specified, but no other user has the

   Have a user who receives the ORA-00054 error when trying to drop a table.  However, no one has the table locked except the user.

Performed the following and found the only the user's id 

select s.sid, s.serial#, p.spid
from v$session s, v$process p
where s.paddr = p.addr and s.sid in (select SESSION_ID from V$LOCKED_OBJECT).

 

Checked the locks and found two locks held for the same table, both by the same sid. There's an exclusive lock and a row exclusive lock held (exclusive, row(x)).

Ran the following statement (to ensure nothing was holding a lock) with the tablename in the object_name and it came up with no rows: