提交事務提示「資料庫被用戶鎖定」。
SELECT object_id, session_id, locked_mode FROM v$locked_object;
SELECT s.username, s.sid, s.serial#, s.logon_time FROM v$locked_object l, v$session s WHERE l.session_id = s.sid ORDER BY s.logon_time;
ALTER SYSTEM KILL SESSION 'sid,serial#'; -- 例 ALTER SYSTEM KILL SESSION '7,10839';
V$LOCK、V$SESSION_WAIT。