Code: Select all
SELECT sid,
serial#,
username
FROM v$session
WHERE sid IN
(SELECT blocking_session FROM v$session
);
Have the session holding the lock commit or roll back
Terminate the session holding the lock (in an emergency)
Code: Select all
SELECT sid,
serial#,
username
FROM v$session
WHERE sid IN
(SELECT blocking_session FROM v$session
);