{"id":1112,"date":"2025-01-07T23:50:17","date_gmt":"2025-01-07T14:50:17","guid":{"rendered":"https:\/\/scrutineer.co.kr\/wordpress\/?p=1112"},"modified":"2025-01-08T09:58:31","modified_gmt":"2025-01-08T00:58:31","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%84%b1%eb%8a%a5-%ea%b3%a0%eb%8f%84%ed%99%94-%ec%9b%90%eb%a6%ac%ed%99%94-%ed%95%b4%eb%b2%95-ch-1-7-8","status":"publish","type":"post","link":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/2025\/01\/07\/%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%84%b1%eb%8a%a5-%ea%b3%a0%eb%8f%84%ed%99%94-%ec%9b%90%eb%a6%ac%ed%99%94-%ed%95%b4%eb%b2%95-ch-1-7-8\/","title":{"rendered":"\uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\ud654 \ud574\ubc95 (Ch.1 &#8211; 7 ~ 8)"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">07 Consistent vs Current \ubaa8\ub4dc \uc77d\uae30<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">07 \ub300\uc81c\ubaa9\uc5d0 \ub098\uc640\uc788\ub4ef, \ube14\ub85d \uc77d\uae30 \ubaa8\ub4dc\uc5d0\ub3c4 \uc5ec\ub7ec\uac00\uc9c0 \ubaa8\ub4dc\uac00 \uc788\uc74c.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Consistent mode\n<ul class=\"wp-block-list\">\n<li>&#8216;\ucffc\ub9ac\ub97c \ub584\ub9b0 \uadf8 \uc2dc\uc810\uc758 SCN\uac12\uc744 \uae30\uc900\uc73c\ub85c \uac12\uc744 \uc77d\uc74c&#8217;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Current mode\n<ul class=\"wp-block-list\">\n<li>&#8216;\ucffc\ub9ac\ub97c \ub584\ub9ac\uace0 \ub098\uc11c, \ub370\uc774\ud130\ub97c \ucc3e\uc544\uac04 \ubc14\ub85c \uadf8 \uc2dc\uc810\uc758 \ucd5c\uc885 \uac12\uc744 \uc77d\uc74c&#8217;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uadfc\ub370&#8230; \uc55e\uc120 SCN\uc774 \uc5b4\uca4c\uace0\uc800\uca4c\uace0 \ud558\ub294\uac78 \ubcf4\uba74&#8230; \ub2e8\uc21c\uc774 SELECT\ud558\ub294 \ucffc\ub9ac\ubb38\uc740 Consistent\ubaa8\ub4dc\ub85c \uc77d\uc9c0 \uc54a\ub098?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub807\uc9c0 \uc54a\uc74c&#8230; DML\uc744 \ud560 \ub54c\uc5d0\ub3c4 &#8220;UPDATE SET A = A+1&#8221; \uacfc \uac19\uc774 \uc774\uc804 \uac12\uc744 \uc77d\uc5b4\uc57c \ud560 \uc2dc\uc810\uc774 \uc788\uc744\uac70\uace0, SELECT FOR UPDATE\ubb38\uacfc \uac19\uc774 UPDATE \uc9c1\uc804\uc5d0 \ub370\uc774\ud130\ub97c \uc77d\ub294 \uacbd\uc6b0\ub3c4 \uc788\uc74c. \uc774\ub54c \ubc14\ub85c \uc624\ub77c\ud074\uc740 Current mode\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ub97c \uc77d\ub294\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ubaa8\ub974\uaca0\uace0&#8230; \uadf8\uc800 &#8216;\uc77c\ubc18\uc801\uc778 \ub2e8\uc21c SELECT\ub294 Consistent mode\ub85c \ub370\uc774\ud130\ub97c \uc77d\uc9c0\ub9cc, \ub2e4\uc74c\uacfc \uac19\uc740 \uc608\uc678 \ucf00\uc774\uc2a4\uc5d0 Current mode\ub85c \ub370\uc774\ud130\ub97c \uc77d\ub294 \uacbd\uc6b0\ub3c4 \uc788\ub2e4&#8217; \uc815\ub3c4\ub97c \uc678\uc6cc\ub450\uc790.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DML<\/li>\n\n\n\n<li>SELECT FOR UPDATE<\/li>\n\n\n\n<li>\ub514\uc2a4\ud06c \uc18c\ud2b8\uac00 \ud544\uc694\ud560 \uc815\ub3c4\ub85c, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc815\ub82c\ud560 \ub54c<\/li>\n\n\n\n<li>\ub4f1\ub4f1\ub4f1\ub4f1&#8230;.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ucc45\uc5d0\uc11c \uac11\uc790\uae30 \ubcc4\ub85c \ud544\uc694\ud560 \uac83 \uac19\uc9c0\ub3c4 \uc54a\uc740 Current mode\uc5d0 \ub300\ud574\uc11c \ub108\uc904\ub108\uc904 \uc124\uba85\uc744 \ud558\uae30 \uc2dc\uc791\ud55c\ub2e4..\ud558\uc9c0\ub9cc Current mode\uac00 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 \ubd84\uba85 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1) Consistent \ubaa8\ub4dc\ub85c\ub9cc \uc77d\ub294 \uacbd\uc6b0<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884-1024x577.jpg\" alt=\"\" class=\"wp-image-1116\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uc0c1\ud669 1..<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">7788\uc0ac\uc6d0\uc758 \ucd08\uae30 sal \uc774 1000\uc778 \uacbd\uc6b0\uc5d0, TX1,TX2\ub97c \ub2e4 \uc218\ud589\ud55c \ub2e4\uc74c\uc758 \ucd5c\uc885 \uacb0\uacfc\uac12\uc740 \ubb50\uac00 \ub098\uc640\uc57c \ud558\ub0a8&#8230;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1\uc7a5 6\uae4c\uc9c0 \uacf5\ubd80\ud574 \ubcf8 \ud559\ubb38\uc801\uc778 \uad00\uc810\uc5d0\uc11c \uc811\uadfc\ud574 \ubcf4\uc790. &#8211;&gt;  Consistent \ubaa8\ub4dc\n<ul class=\"wp-block-list\">\n<li>TX2\uc2dc\uc810\uc5d0\uc11c \uc77d\uc5b4\uc628 sal\uac12\uc774 1,000\uc73c\ub85c \uc77d\uc5b4\uc57c \ud558\ub2c8, 1200\uc6d0\uc774 \ub418\uc5b4\uc57c \ud560 \uac83\uc774\ub124.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \ub09c (\uac1c\ub098\uc18c\ub098 \ud558\ub294\uac70\uc9c0\ub9cc) \ubb34\ub824 \ucee4\uba38\uc2a4 \uc11c\ube44\uc2a4 \uac1c\ubc1c\uc790\ub2e4&#8230;.. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc800\uac8c&#8230;\ub9de\uc544?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Current \ubaa8\ub4dc\uc801\uc778 \uad00\uc810\uc5d0\uc11c \uc0dd\uac01\ud574 \ubcf4\uc790.\n<ul class=\"wp-block-list\">\n<li>TX1\uc2dc\uc810\uc5d0\uc11c \uc5c5\ub370\uc774\ud2b8 \ub418\ub294 \uac12\ub3c4, \uc0ac\uc2e4 \uc5c4\uc5f0\ud788 \uc815\uc0c1\uc801\uc778 \uc11c\ube44\uc2a4 \ucffc\ub9ac\uc784.<\/li>\n\n\n\n<li>7788\uc0ac\uc6d0\uc758 \ucd5c\uc885 sal\uac12\uc774 1,300\uc774\uc5b4\uc57c \uc544\ubb34\ub798\ub3c4 \ubb38\uc81c\uac00 \uc548 \uc0dd\uae30\uc9c0 \uc54a\uaca0\uc74c&#8230;?<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Consistent\ubaa8\ub4dc\uc758 \uad00\uc810\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \uc800 \ubb38\uc81c\uc0c1\ud669\uc744 &#8216;Lost Update&#8217; \ucf00\uc774\uc2a4\ub77c\uace0 \uce6d\ud558\uace0, \uc774 \ubb38\uc81c\ub97c \ud68c\ud53c\ud558\ub824\uba74, \uac31\uc2e0 \uc791\uc5c5\uc740 Current \ubaa8\ub4dc\ub85c \uc77d\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub807\uad6c\ub098&#8230;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub7fc \ub2e4\uc74c\ud604\uc0c1.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2) Current \ubaa8\ub4dc\ub85c\ub9cc \uc77d\ub294 \uacbd\uc6b0<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_01-1024x577.jpg\" alt=\"\" class=\"wp-image-1117\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_01-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_01-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_01-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_01-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_01.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uc5b4\ub835\ub2e4&#8230;<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">7788 \uc0ac\uc6d0\uc758 \ucd5c\uc885\uc801\uc778 sal \uac12\uc740 \uc5b4\ub5a4 \uac12\uc774 \ub098\uc640\uc57c \ud558\ub0a8&#8230;.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>2000\uc774 \ub098\uc640\uc57c \ub9de\ub098? 3000\uc774 \ub098\uc640\uc57c \ub9de\ub098? <\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ub2e8 Current \ubaa8\ub4dc\ub85c \uc77d\ub294 \uacbd\uc6b0\ub97c \ub530\uc838\ubd24\uc744 \ub550,  TX2\uac00 \uc77d\ub294 \uc2dc\uc810\uc774 7788\uc0ac\uc6d0\uc758 sal\uc774 2000\uc73c\ub85c \ucc0d\ud600\uc788\uae30\uc5d0 \ucd5c\uc885\uc801\uc73c\ub85c 3000\uc774 \ub098\uc624\uac8c \ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub7fc \uc774 \uacbd\uc6b0\ub294&#8230;?<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_02-1-1024x577.jpg\" alt=\"\" class=\"wp-image-1118\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_02-1-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_02-1-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_02-1-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_02-1-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/KakaoTalk_20250107_231859884_02-1.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uc5b4\ub835\ub2e42&#8230;..<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">t\ud14c\uc774\ube14\uc758 no\uac00 1~100,000\uae4c\uc9c0 \uc788\ub2e4\uace0 \ud588\uc744 \ub584, TX1\uacfc TX2\uac00 \uc0c1\ud669 3\uacfc \uac19\uc740 \ud2b8\ub79c\uc7ad\uc158 \uc0c1\ud669\uc5d0\uc11c \uc5c5\ub370\uc774\ud2b8\uac00 \uc774\ub8e8\uc5b4 \uc9c0\uba74, \ucd5c\uc885\uc801\uc73c\ub85c TX1\uc774 \uc5c5\ub370\uc774\ud2b8 \uce5c row count\ub294 5\ub9cc\uac74\uc774\uc5b4\uc57c \ud560\uae4c? 5\ub9cc+1\uac74\uc774\uc5b4\uc57c \ud560\uae4c?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc2e4\uc81c\ub85c SQL Server\uc5d0\uc11c \uc218\ud589\ud558\uba74 5\ub9cc+1\uac74\uc774 \uc218\ud589\ub41c\ub2e4\uace0 \ud55c\ub2e4. &#8211;&gt; Current\ubaa8\ub4dc\ub85c \uac31\uc2e0\uc744 \ud55c\ub2e4\ub294 \ub73b.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Consistent \ubaa8\ub4dc\ub85c \uc77d\uace0, Current \ubaa8\ub4dc\ub85c \uac31\uc2e0\ud560\ub54c \uc0dd\uae30\ub294 \ud604\uc0c1<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Current \ubaa8\ub4dc\ub85c \uac31\uc2e0\uc744 \uc218\ud589\ud560 \ub54c\uc5d0\ub3c4 \uc77c\uad00\uc131\uc774 \uc5c6\ub294 \ubaa8\uc2b5\uc758 \uc608\uc2dc\uac00 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub798\uc11c \uc624\ub77c\ud074\uc740,  Consistent\ubaa8\ub4dc\ub85c \uc77d\uace0 &amp; Current\ubaa8\ub4dc\ub85c \uac31\uc2e0\uc744 \uc218\ud589\ud55c\ub2e4. &#8211;&gt; \ub4a4\uc5d0 \ub098\uc624\uaca0\uc9c0\ub9cc \ub2e8\uc21c\ud788 &#8216;Consistent\ubaa8\ub4dc\ub85c \uc77d\ub294&#8217; \uac83\uc774 \uc544\ub2c8\ub77c, &#8216; Consistent\ubaa8\ub4dc\ub85c \uac31\uc2e0\ub300\uc0c1\uc744 \uc2dd\ubcc4\ud55c\ub2e4&#8217; \ub77c\ub294 \ud45c\ud604\uc774 \uc801\uc808\ud558\uaca0\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074227-1024x577.jpg\" alt=\"\" class=\"wp-image-1121\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074227-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074227-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074227-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074227-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074227-2048x1153.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074235-1024x577.jpg\" alt=\"\" class=\"wp-image-1122\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074235-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074235-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074235-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074235-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_074235-2048x1153.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">sal\uc758 \ucd08\uae30\uac12\uc774 1,000\uc774\ub77c \ud560 \ub54c, \uc774\uc640 \uac19\uc740 \uc0c1\ud669\uc5d0\uc11c\uc758 7788\uc0ac\uc6d0\uc758 sal\uac12\uc740 \uc5b4\ub5bb\uac8c \ub418\ub294\uac78\uae4c?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1,100? 1,300?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Consistent\ubaa8\ub4dc\ub85c \uc77d\uace0 Current\ubaa8\ub4dc\ub85c \uac31\uc2e0\ud55c\ub2e4\uba74, 1,300\uc774\ub77c\ub294 \uac12\uc774 \ub098\uc640\uc57c \ud558\ub294 \uac83\uc774 \uc633\uaca0\uc73c\ub098&#8230;. \uadf8\ub7fc \uacb0\uad6d &#8216;\uc774\ubbf8 1,100\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8 \ub41c \uac12\uc744 \uc7ac\uc0dd\uae34 \ud558\ub294&#8217; \uc2e0\ub8b0\uc131 \uc5c6\ub294 \ub3d9\uc791\uc744 \ud558\ub294 \uacb0\uacfc\ub97c \ub0b3\uac8c\ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \uc624\ub77c\ud074\uc5d0\uc11c\ub3c4 TX2\uc758 \uac31\uc2e0\uc740 \uc2e4\ud328\ud55c\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Consistent\ubaa8\ub4dc\ub85c \uac31\uc2e0\ub300\uc0c1\uc744 \uc2dd\ubcc4\ud558\uace0, Currrent\ubaa8\ub4dc\ub85c \uac31\uc2e0<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_075639-1024x577.jpg\" alt=\"\" class=\"wp-image-1123\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_075639-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_075639-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_075639-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_075639-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2025\/01\/20250108_075639-2048x1153.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc218\ub3c4\ucf54\ub4dc\ub85c \ud45c\ud604\ud558\uba74 \uc704\uc758 \uadf8\ub9bc\ucc98\ub7fc \uc218\ud589\uc774 \ub418\ub294\ub370, \uc774\uac78 \ub2e8\uacc4 1\/2\ub85c \ub098\ub204\uc5b4\uc11c \ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Consistent\ubaa8\ub4dc\ub85c \uc77c\ub2e8 \uac31\uc2e0\ud560 \ub808\ucf54\ub4dc\ub97c \uc77d\ub294\ub2e4.<\/li>\n\n\n\n<li>1\ub2e8\uacc4\uc5d0\uc11c \uc77d\uc740 rowid\ub97c \ucc3e\uc544\uac00 low lock\uc744 \uc124\uc815\ud55c \ub2e4\uc74c\ub370, Current\ubaa8\ub4dc\ub85c \uac31\uc2e0\uc744 \uc218\ud589\ud55c\ub2e4. \uc774\ub54c, 1\ub2e8\uacc4\uc5d0\uc11c \uc77d\uc740 where\uc870\uac74\uc744 \uc2e0\ub8b0\ud558\uc9c0 \uc54a\uace0, \ucd5c\uc885 \uac31\uc2e0 \uc9c1\uc804\uc5d0 Current\ubaa8\ub4dc\ub85c \ub2e4\uc2dc \ud55c\ubc88 \uc870\uac74\uc744 \uccb4\ud06c\ud558\uace0 \uac31\uc2e0\uc744 \ud55c\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\ub77c\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\ub2e8\uacc4\uc5d0\uc11c \uac31\uc2e0\ud560 \ub808\ucf54\ub4dc\ub97c \uc77d\ub294\ub2e4\uace0 \ud574\uc11c, &#8216;\uc774 \uce5c\uad6c\ub4e4\uc744 \ubaa8\ub450 \ub2e4 \uc5c5\ub370\uc774\ud2b8 \ud560\uac70\uc57c&#8217; \ud558\ub294\uac8c \uc544\ub2c8\ub77c, &#8216;\uc2e4 \uc5c5\ub370\uc774\ud2b8 \uc9c1\uc804\uc5d0 \ub610 \ud55c\ubc88 \uccb4\ud06c\ub97c \ud55c\ub2e4&#8217; \ub77c\ub294 \uac1c\ub150\uc73c\ub85c \ub3d9\uc791\ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uadf8\ub7fc \ub2e8\uacc4 1\uc740 \uc65c \ud544\uc694\ud55c\ub370?<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uac31\uc2e0\uc774 \uc9c4\ud589\ub418\ub294 \ud0c0\uc774\ubc0d\uc5d0, &#8220;\uc81c 3\uc758 \ud2b8\ub79c\uc7ad\uc158\uc774 7788\uc0ac\uc6d0\uc758 sal\uc744 1,000\uc73c\ub85c \ubcc0\uacbd\ud558\ub294 \ub3d9\uc791\uc774 \ucd94\uac00\ub85c \uc9c4\ud589\ub420 \uc218\ub3c4 \uc788\uc5b4\uc11c&#8221; \uc784.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac31\uc2e0\uc774 \uc9c4\ud589\ub418\ub294 \ub3d9\uc548 \ucd94\uac00\/\ubcc0\uacbd\uc744 \ud1b5\ud574 &#8220;\uc0c8\ub86d\uac8c \ubc94\uc704 \uc548\uc5d0 \ub4e4\uc5b4\uc640\ubc84\ub9ac\ub294 \ub808\ucf54\ub4dc\ub97c \uc81c\uc678\ud558\uae30 \uc704\ud568&#8221; \uc774\ub77c\uace0 \ud45c\ud604\ud574\ub3c4 \ub418\uace0.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc544\ubb34\ud2bc \uadf8\ub9ac\ud558\uc5ec, \uc624\ub77c\ud074\uc740 \uc0c1\uae30\uc758 \uc0c1\ud669\uc5d0\uc11c\ub3c4 TX2\uc5d0\uc11c \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud558\uc9c0 \ubabb\ud558\ub294 \uac31\uc2e0\uc744 &#8216;Consistent\ubaa8\ub4dc\ub85c \uac31\uc2e0\ub300\uc0c1 \uc2dd\ubcc4 &amp;&amp;  Current\ubaa8\ub4dc\ub85c \uac31\uc2e0&#8217; \ud558\ub294 \ubc29\ubc95\uc744 \ud1b5\ud574 \uc77c\uad00\uc131 \ubcf4\uc7a5\uc744 \ud574 \uc900\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uadf8\ub7fc\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 \uc77c\uad00\uc131 \uc5c6\uac8c \uac12\uc744 \uac31\uc2e0\ud558\ub294 \uc0ac\ub840<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>7788\uc0ac\uc6d0\uc758 &#8216;\uacc4\uc88c1&#8217; \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130<\/td><td>7788\uc0ac\uc6d0\uc758 &#8216;\uacc4\uc88c2&#8217; \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130<\/td><\/tr><tr><td>\uc794\uace0 : 1,000<\/td><td>\uc794\uace0 : 1,000<br>\ucd1d\uc794\uace0 : 2,000 (\uacc4\uc88c1 + \uacc4\uc88c2 \uc758 \ucd1d \uc794\uace0\ub97c \uc800\uc7a5\ud558\ub294 \uceec\ub7fc)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc694\ub54c \ub2e4\uc74c\uacfc \uac19\uc740 \ub3d9\uc791\uc744 \uc218\ud589\ud558\uba74 \uc774\ub7f0 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TX1&gt; UPDATE \uacc4\uc88c1 set \uc794\uace0=\uc794\uace0+100 WHERE 7788;\nTX2&gt; UPDATE \uacc4\uc88c2 set \uc794\uace0=\uc794\uace0+200 WHERE 7788;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub450\uac1c\uc758 \ud2b8\ub79c\uc7ad\uc158\uc774 \ub3d9\uc2dc\uc5d0 \uc218\ud589\ub420 \ub54c, \uc6d0\ud558\ub294 \uacc4\uc88c2\uc758 &#8216;\ucd1d\uc794\uace0&#8217; \uceec\ub7fc\uc740 2,300\uc774 \ub418\uc5b4\uc57c \ud558\ub294\ub370, 2,200\uc73c\ub85c \ucc0d\ud78c\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uacc4\uc88c2\uc5d0\uc11c \uc794\uace0\ub97c \uc77d\uc744\ub550 Current\ubaa8\ub4dc\uc5d0\uc11c \uc77d\uc9c0\ub9cc, \uacc4\uc88c1\uc5d0\uc11c \uc794\uace0\ub97c \uc77d\uc744\ub550 Consistent\ubaa8\ub4dc\ub85c \uc77d\uae30 \ub54c\ubb38\uc774\ub77c\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub798\uc11c \uc774\ub7f0 \uacbd\uc6b0\uc5d0 \uc62c\ubc14\ub974\uac8c \uac12 \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud558\ub824\uba74 TX2\uc5d0 \ucffc\ub9ac\ub97c \uc774\ub7f0 \uc2dd\uc73c\ub85c \ubcc0\uacbd\ud558\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TX2&gt; UPDATE \uacc4\uc88c2 set \ucd1d\uc794\uace0 = (SELECT \uc794\uace0+ \uacc4\uc88c2.\uc794\uace0 FROM \uacc4\uc88c1 WHERE \uacc4\uc88c = \uacc4\uc88c2.\uacc4\uc88c\ubc88\ud638)\n           WHERE 7788;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub584 \uacc4\uc88c1,2 \uc794\uace0\ub97c \ubaa8\ub450 Current\ubaa8\ub4dc\ub85c \uc77d\uae30 \ub584\ubb38\uc5d0, TX2\uc758 \ucffc\ub9ac\ub97c 2,300\uc73c\ub85c \ucc0d\ub294\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(\uc5b4&#8230;..\ubcf4\ud1b5\uc740 \uc774\ub7ec\uba74 \uadf8\ub0e5 \ud2b8\ub79c\uc7ad\uc158\uc774 \uc548\uacb9\uce58\uac8c \uc2dc\uac04\ucc28\ub97c \ub450\uace0 \ubc30\uce58\ub97c \uc218\ud589\ud558\uac70\ub098 \ud560 \uac83 \uac19\uae34 \ud558\ub2e4&#8230; \ubd88\ud655\uc2e4\uc131\uc774 \ub108\ubb34 \ud07c&#8230;)<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">08 \b\ube14\ub85d \ud074\ub9b0\uc544\uc6c3<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\uac04\ub2e8\ud558\ub2e4&#8230; \ub300\ub7c9 DML\uc774\ud6c4 \ucee4\ubc0b \uc2dc, \ucee4\ubc0b \uc644\ub8cc\ub97c \uac01 \ube14\ub85d\uc744 \ucc3e\uc544\ub2e4\ub2c8\uba70 \ube14\ub85d \ud074\ub9b0\uc544\uc6c3\uc744 \uc218\ud589\ud558\ub294\uac74 \ub108\ubb34 \uc624\ub798 \uac78\ub9ac\uae30\uc5d0, \uc131\ub2a5 \ucd5c\uc801\ud654\ub97c \uc704\ud55c \uae30\ubc95\uc744 \uc124\uba85\ud574 \uc8fc\uace0 \uc788\ub2e4<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Delayed \ube14\ub85d \ud074\ub9b0\uc544\uc6c3<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc84\ud37c\uce90\uc2dc \ube14\ub85d \uac1c\uc218\uc758 10% \uc774\uc0c1\uc744, \ud2b8\ub79c\uc7ad\uc158\uc774 \uac31\uc2e0\ud55c \ube14\ub85d \uac1c\uc218\uac00 \ucc28\uc9c0\ud560\ub54c \ub51c\ub808\uc774 \ube14\ub85d \ud074\ub9b0\uc544\uc6c3\uc744 \uc9c4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub51c\ub808\uc774 \uc2dc\uc810 : \ucee4\ubc0b \uc774\ud6c4, \ud574\ub2f9 \ube14\ub85d\uc774 \ucd5c\ucd08\ub85c read\ub418\ub294 \uc2dc\uc810\uc5d0 \ud074\ub9b0\uc544\uc6c3.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucee4\ubc0b \ud074\ub9b0\uc544\uc6c3<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc624\ub77c\ud074\uc774 \uadf8\ub807\ub2e4\uace0 \ucd5c\uc801\ud654\ub41c \ud074\ub9b0\uc544\uc6c3 \ubc29\uc2dd\uc744 Delayed \ube14\ub85d \ud074\ub9b0\uc544\uc6c3\ub9cc \uc4f0\uba74, \ub300\ub7c9 SELECT\ub54c \ub610 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ucc45\uc5d0\uc11c\ub294 RAC OPS\uc758 \uc608\uc2dc\ub97c \ub4e4\uc5b4 \uc774\uc57c\uae30 \ud558\ub294\ub370&#8230; \uc0ac\uc2e4 \uc774\ud574\uac00 \uc798 \uac00\uc9c0 \uc54a\uc544\uc11c \uadf8\ub0e5 \ud328\uc2a4.. (\ubcc4\ub85c \uc911\uc694\ud558\uc9c0 \uc54a\uc740 \uac83 \uac19\uae30\ub3c4 \ud558\uace0)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">OPS\ud658\uacbd\uc5d0\uc11c \uc778\uc2a4\ud134\uc2a4\uac04\uc5d0 \ube14\ub85d\uc744 \uc8fc\uace0\ubc1b\ub294 \uacfc\uc815\uc778 &#8216;\ud551&#8217;\uc774\ub780\uac78 \ud558\ub294\ub370, \uc774 &#8216;\ud551&#8217;\uc774 \uacfc\ub3c4\ud558\uac8c \ubc1c\uc0dd\ud558\ub294\uac78 \ub9c9\uc544\uc8fc\ub294 \uc5ed\ud560\uc744 \ud55c\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ITL\uacfc \ube14\ub85d \ud074\ub9b0\uc544\uc6c3<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">&#8230;..<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>07 Consistent vs Current \ubaa8\ub4dc \uc77d\uae30 07 \ub300\uc81c\ubaa9\uc5d0 \ub098\uc640\uc788\ub4ef, \ube14\ub85d \uc77d\uae30 \ubaa8\ub4dc\uc5d0\ub3c4 \uc5ec\ub7ec\uac00\uc9c0 \ubaa8\ub4dc\uac00 \uc788\uc74c. \uadfc\ub370&#8230; \uc55e\uc120 SCN\uc774 \uc5b4\uca4c\uace0\uc800\uca4c\uace0 \ud558\ub294\uac78 \ubcf4\uba74&#8230; \ub2e8\uc21c\uc774 SELECT\ud558\ub294 \ucffc\ub9ac\ubb38\uc740 Consistent\ubaa8\ub4dc\ub85c \uc77d\uc9c0 \uc54a\ub098? \uadf8\ub807\uc9c0 \uc54a\uc74c&#8230; DML\uc744 \ud560 \ub54c\uc5d0\ub3c4 &#8220;UPDATE SET A = A+1&#8221; \uacfc \uac19\uc774 \uc774\uc804 \uac12\uc744 \uc77d\uc5b4\uc57c \ud560 \uc2dc\uc810\uc774 \uc788\uc744\uac70\uace0, SELECT FOR UPDATE\ubb38\uacfc \uac19\uc774 UPDATE \uc9c1\uc804\uc5d0 \ub370\uc774\ud130\ub97c \uc77d\ub294 \uacbd\uc6b0\ub3c4 \uc788\uc74c. &#8230; <a title=\"\uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\ud654 \ud574\ubc95 (Ch.1 &#8211; 7 ~ 8)\" class=\"read-more\" href=\"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/2025\/01\/07\/%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%84%b1%eb%8a%a5-%ea%b3%a0%eb%8f%84%ed%99%94-%ec%9b%90%eb%a6%ac%ed%99%94-%ed%95%b4%eb%b2%95-ch-1-7-8\/\" aria-label=\"Read more about \uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\ud654 \ud574\ubc95 (Ch.1 &#8211; 7 ~ 8)\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1112","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=1112"}],"version-history":[{"count":4,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1112\/revisions"}],"predecessor-version":[{"id":1126,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1112\/revisions\/1126"}],"wp:attachment":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=1112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=1112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=1112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}