2022.06.05 / 23:38
¿À¶óŬ ¶ô ÇØÁ¦ ¹æ¹ý - LOCK °³Ã¼ È®ÀÎ
ŹÃÄ
Ãßõ ¼ö 123
¿À¶óŬ µðºñ¿¡¼ ¶ôÀÌ °É¸®´Â ÀÌÀ¯´Â ´Ù¾çÇÕ´Ï´Ù.
´©±º°¡ sql ½ÇÇà Áß CommitÀ» ¾È Çß´Ù´øÁö, ¹èÄ¡°¡ ½ÇÇà ÁßÀ̶ó´øÁö µîµî
Truncate °°Àº ¸í·ÉÀº ORA-00054¶ó´Â ¿¡·¯¶óµµ Ãâ·ÂÇÏÁö¸¸...
DML(Delete) ¹®Àå ½ÇÇà ½Ã ±×³É ¸ØÃĹö¸³´Ï´Ù.
¿À¶óŬ Àç½ÃÀÛ!!!
ÇÏ¸é °£´ÜÇÏ°Ô Ã³¸®µË´Ï´Ù¸¸.--^^;
ÇÏÁö¸¸ DB Ư¼º»ó Àç½ÃÀÛ ÇÒ ¼ö ¾ø´Â °æ¿ì°¡ ¸¹ÁÒ~
±×¶§´Â Lock °É¸° ¼¼¼ÇÀ» ã¾Æ¼..Kill ÇØÁÖ¸é µË´Ï´Ù.
¡Ø ¾Æ·¡ ÀÛ¾÷Àº »ç¿ëÀÚ °èÁ¤À¸·Î´Â Á¶È¸°¡ ¾ÈµÇ´Ï °ü¸®ÀÚ ±ÇÇÑÀ¸·Î ÇÏ¿©¾ß ÇÕ´Ï´Ù.
(SYSTEM °èÁ¤À¸·Î ·Î±×ÀÎ)
1. ¸ÕÀú, TABLEÀÇ LOCK(¶ô) °´Ã¼ °Ë»öSELECT A.SID , A.SERIAL# , C.OBJECT_NAME , A.SID || ', ' || A.SERIAL# AS KILL_JOB FROM V$SESSION A, V$LOCK B, DBA_OBJECTS C WHERE A.SID = B.SID AND B.ID1 = C.OBJECT_ID AND B.TYPE = 'TM' -- AND C.OBJECT_NAME = 'JAMES_MAIL' -- ÇØ´ç Å×À̺íÀÌ ÀÖÀ¸¸é ÁöÁ¤ÇÒ ¼ö ÀÖ´Ù. ;
À§ÀÇ ½ÇÇà°á°ú ¼¼¼Ç °ª
SID SERIAL# ------- ---------- 2715 40427
2. ½ÇÇà °á°ú¿¡ µû¸¥ ¼¼¼Ç Á×À̱â ( KILL SESSION)# KillÀº ÀÌ·¸°Ô... alter system kill session '2715,40427';
ÀÌ·¸°Ô ã¾ÆÁö¸é Á×ÀÏ ¼ö ÀÖ½À´Ï´Ù.
¼ö°íÇϼ̽À´Ï´Ù.~~
Ãâó: https://softone.tistory.com/62 [¼ÒÇÁÆ®¿ø:Ƽ½ºÅ丮]