donnert.net

락 찾기 SELECT c.owner, c.object_name, c.object_type, b.SID, b.serial#, b.status, b.osuser, b.machine FROM v$locked_object a, v$session b, dba_objects c WHERE b.SID = a.session_id AND a.object_id = c.object_id; 세션 죽이기 alter system kill session '81, 45548'; 그래도 안 죽을 경우(ORA-00031 발생할 경우) PID 확인 select vs.sid, vs.username, vs.osuser, vs.process fg_pid, vp.spid bg_pid from v$session vs, v$process vp wh..