블로그

• Dear readers, revisited the aftermath again in a new book, a work of autofiction called “If You Love It, Let It Kill You,” and she spoke to my colleague Alexandra Alter about it this week. blog.naver.com · 2025.07.13
• ORA-00054: 자원이 사용중이고, NOWAIT가 지정되어 있습니다. DBA_OBJECTS C WHERE A.SID = B.SID AND B.ID1 = C.OBJECT_ID AND B.TYPE = 'TM' AND C.OBJECT_NAME = 'TABLE' ; ALTER SYSTEM KILL SESSION 'SID,SERIAL'; blog.naver.com · 2022.05.24
• KILL SESSION -- SID 및 시리얼 확인 SELECT * FROM V$SESSION S , V$PROCESS P WHERE S.PADDR = P.ADDRAND S.SID = '292' --KILL ALTER SYSTEM KILL SESSION '314,1138' -- SID,SERIAL# -- KILL WITH OPTION ALTER SYSTEM DISCONNECT SESSION blog.naver.com · 2011.05.16
• oracle 에러 상세설명 ======================================================================ORA-00030 : ALTER SYSTEM KILL SESSION에 OS 나 Oracle 의 자원을 지나치게 많이 사용하여 성능을 저하시키는 process 그런데, alter system kill session ('sid, serial#'); ... blog.naver.com · 2009.03.19