{"id":1074,"date":"2024-06-10T14:44:25","date_gmt":"2024-06-10T05:44:25","guid":{"rendered":"https:\/\/scrutineer.co.kr\/wordpress\/?p=1074"},"modified":"2024-12-24T11:21:41","modified_gmt":"2024-12-24T02:21:41","slug":"%e3%85%85%e3%84%b7%e3%84%b4%e3%85%85","status":"publish","type":"post","link":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/2024\/06\/10\/%e3%85%85%e3%84%b7%e3%84%b4%e3%85%85\/","title":{"rendered":"\uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\uc640 \ud574\ubc95 (Ch.1 1~5)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">01 \uae30\ubcf8 \uc544\ud0a4\ud14d\uccd0<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">DBA\uac00 \uc544\ub2cc \uc774\uc0c1 \uadf8\ub807\uac8c \uc911\uc694\ud55c \uc6a9\uc5b4 \ubc0f \uac1c\ub150\uc774 \uc788\uc5b4\ubcf4\uc774\uc9c4 \uc54a\ub294\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc911\uac04\uc5d0 &#8216;\ub514\uc2a4\ud06c \uc561\uc138\uc2a4 \uc554&#8217; \uc774\uc57c\uae30\uac00 \ub098\uc624\uae30\ub3c4 \ud558\uace0&#8230;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud559\ubd80\uc2dc\uc808 \uac1c\ub860 \uc218\uc900\uc73c\ub85c \uc774\uc57c\uae30 \ub418\ub294 Multi User One Resource\uac1c\ub150\uc744 \ud6d1\uace0 \ub118\uc5b4\uac00\ub294 \uc815\ub3c4\ub77c\uc11c \ub300\uac1c\ub294 \uc0dd\ub7b5\ud574\ub3c4 \ub428.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \uc911\uc694\ud55c \ud575\uc2ec \ud0a4\uc6cc\ub4dc \uba87\uac1c\ub294 \uc874\uc7ac. \uc774 \ubd80\ubd84\ub9cc \uc9da\uace0 \uac04\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Latch<\/li><li>SGA (System Global Area)<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">multi user\uc758 \ud2b9\uc9d5\uc778, \uacbd\ud569 \uc0c1\ud0dc\uc5d0\uc11c\uc758 \uacf5\uc720\uba54\ubaa8\ub9ac\ub97c \ubb34\ubd84\ubcc4\ud558\uac8c \uac74\ub4dc\ub9ac\ub294 \ucf00\uc774\uc2a4\uc5d0\uc11c\ub294 \uc77d\uae30\/\uc4f0\uae30 \uc77c\uad00\uc131\uc774 \ubcf4\uc7a5\uc774 \uc548\ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc774 \ub54c, SGA\ub77c\ub294 \uacf5\uc720 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc758 \ub370\uc774\ud130 \uc5d1\uc138\uc2a4\ub97c \ubcf4\ud638\ud558\uae30 \uc624\ub77c\ud074\uc740 (\ub2f9\uc5f0\ud788) \ub77d\uc744 \uc0ac\uc6a9\ud558\uace0, \uc774 \ub77d \uba54\ucee4\ub2c8\uc998\uc744 &#8216;Latch&#8217;\ub77c\uace0 \ud55c\ub2e4.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub9ac\uace0 SGA\uc5d0\ub294 \ubb50 shared pool, Buffer cache, redo log buffer\ub4f1, \uc8c4\ub2e4 \ucc98\uc74c \ub4e4\uc5b4\ubcf4\ub294 \uc6a9\uc5b4\ub4e4\uc774 \uac00\ub4dd\uac00\ub4dd..<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ucc55\ud130\uc5d0\uc11c \uac00\uc7a5 \uc911\uc694\ud558\uac8c \uc0dd\uac01\ud560 \ub9cc\ud55c \uc694\uc18c \ubc0f \uc6a9\uc5b4\ub294 \uc774\uac83\uc77c \ub4ef \ud558\ub2e4. (\ubb3c\ub860 \uae4a\uac8c \uacf5\ubd80\ud55c\ub2e4\uba74 \ub05d\uc774 \uc5c6\uc744\ud14c\uc9c0\ub9cc, \ub09c DBA\uac00 \uc544\ub2c8\ub77c \uc11c\ube44\uc2a4 \uac1c\ubc1c\uc790\uc774\uae30\uc5d0 &#8216;\uadf8\ub807\ub2e4\ub354\uad6c\ub098&#8217; \uc815\ub3c4\ub85c\ub9cc \uc774\ud574\ud560 \uc0dd\uac01)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\uc624\ub77c\ud074\uc740 multi user \uae30\ubc18\uc758 \ub2e4\uc911 \uc811\uc18d\uc744 \uc9c0\uc6d0\ud55c\ub2e4<\/li><li>\uc624\ub77c\ud074\ub3c4 \ud558\ub098\uc758 \ubb3c\ub9ac\uc11c\ubc84\uac00 \uc544\ub2c8\ub77c \uc5ec\ub7ec\ub300\uc758 \uc778\uc2a4\ud134\uc2a4\ub85c \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud55c\ub2e4 &#8211;> RAC(Real Application Cluster) \ud658\uacbd\uc774\ub77c\uace0 \ud568<ul><li>\uc5b4? \uadf8\ub807\ub2e4\uba74, RAC\ud658\uacbd\uc5d0\uc11c\uc758 \ub370\uc774\ud130 \uc77c\uad00\uc131\uc744 \uc5b4\ub5bb\uac8c \ubcf4\uc7a5\ud558\uace0 \uc788\ub294\uac00?<\/li><li>\uc911\uac04\ub370 \uae00\ub85c\ubc8c \uce90\uc2dc \ub808\uc774\uc5b4\uac00 \uc788\ub2e4. RAC\uad6c\uc870\uc758 \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \uc804\uc6a9\ub9dd\uc744 \ud1b5\ud574 \ub370\uc774\ud130 \ub3d9\uae30\ud654\ub97c \uc774\ub8f8<\/li><\/ul><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">02 DB \ubc84\ud37c \uce90\uc2dc<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SGA\ub77c\ub294 \uacf5\uc720\uba54\ubaa8\ub9ac \ub0b4\uc5d0\uc11c\ub3c4, \uc6b0\ub9ac\uac00 \ud754\ud788 \uc778\uc9c0\ud558\ub294 &#8216;SELECT\/DML\ub4f1\uc744 \ud1b5\ud574 read\/write \ud55c \ub370\uc774\ud130\ub97c \uc2e4\uc81c \ube14\ub85d\uc5d0 read\/write\ud558\ub294\ub370 \uc788\uc5b4\uc11c \uc911\uac04\uc5d0 \uce90\uc2dc \uc5ed\ud560\uc744 \ud558\ub294 \uce5c\uad6c\ub97c &#8216;DB \ubc84\ud37c \uce90\uc2dc(\ubc84\ud37c\uce90\uc2dc)&#8217; \ub77c\uace0\ub4e4 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ucc55\ud130\uc758 \uc2dc\uc791\uc5d0\uc11c\ub294, &#8216;\uc624\ub77c\ud074\uc740 \ube14\ub85d \ub2e8\uc704\ub85c I\/O\ub97c \ud55c\ub2e4&#8217; \ub77c\ub294 \uc124\uba85\uc744 \ud558\uace0, \uc774 &#8216;\ube14\ub85dI\/O&#8217; \uac00 \uc131\ub2a5\uc5d0 \uc788\uc5b4\uc11c \ub9e4\uc6b0 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud55c\ub2e4\uace0 \uba87\ubc88\uc774\ub098 \uac15\uc870\ud55c\ub2e4.<br>\ud558\uc9c0\ub9cc \ub09c \uc774\ud574\ub97c \ubabb\ud588\ub2e4. \ub514\uc2a4\ud06c \ube14\ub85d\uc77c\uc9c0&#8230;. \uadf8\ub0e5 \uac00\uc0c1 \uac1c\ub150\uc758 &#8216;\ube14\ub85d&#8217;\uc77c\uc9c0 \uac10\uc774 \uc798 \uc548\uc7a1\ud798. \ube14\ub85dI\/O\uc758 \uac1c\ub150\uc774 SSD\uac00 \ub098\uc624\uba74\uc11c\ubd80\ud130 \uc880 \ub2ec\ub77c\uc9c0\uae30\ub3c4 \ud588\uc744\uac70\uace0&#8230;&#8230;..<br>\uc624\ub77c\ud074 \ud29c\ub2dd \uad00\uc810\uc5d0\uc11c\uc57c \uc911\uc694\ud558\uaca0\uc9c0\ub9cc \uc77c\ub2e8 &#8216;\ube14\ub85dI\/O\uae30\ubc18\uc774\ub2e4&#8217; \ub97c \uc678\uc6cc\ub450\uace0 \uc774\ud6c4 \ub0b4\uc6a9\ub4e4\uc744 \ubcf4\uba74 \uc774\ud574\uac00 \uac00\uaca0\uc9c0&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ucc55\ud130\uc5d0\uc11c \uac15\uc870\ud558\ub294\uac74, \ubc84\ud37c\uce90\uc2dc\uc758 \uad6c\uc870\uc640 &#8216;\uc5b4\ub5a4 \ubc29\uc2dd\uc73c\ub85c \ubc84\ud37c\uce90\uc2dc\uac00 \uce90\uc2dc\ub370\uc774\ud130\ub97c \ube60\ub978 \uc2dc\uac04\ubcf5\uc7a1\ub3c4\ub85c \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud558\ub294\uc9c0&#8217; \uc5d0 \ub300\ud55c \uc124\uba85\uc774 \ub4e4\uc5b4\uac00\uc788\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\/2024\/12\/20241224_105710-1024x577.jpg\" alt=\"\" class=\"wp-image-1092\" srcset=\"https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2024\/12\/20241224_105710-1024x577.jpg 1024w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2024\/12\/20241224_105710-300x169.jpg 300w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2024\/12\/20241224_105710-768x432.jpg 768w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2024\/12\/20241224_105710-1536x865.jpg 1536w, https:\/\/scrutineer.co.kr\/wordpress\/wp-content\/uploads\/2024\/12\/20241224_105710-2048x1153.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>\uae00\ub85c \uc4f0\uba74 \ud55c\ub3c4\ub05d\ub3c4 \uc5c6\uc744 \uac83 \uac19\ub2e4..<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ub2e8 \ubc84\ud37c\uce90\uc2dc\uc758 \ubc84\ud37c\ube14\ub85d\uc740, \ud754\ud788 \uc0dd\uac01\ud558\ub294 RAM\uc758 random access\uc758 \uad6c\uc870\ub97c \ub530\ub974\uace0 \uc788\uc5b4\uc11c, \uc21c\ucc28 \uc811\uadfc\uc774 \ubd88\uac00\ub2a5\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub798\uc11c, \ud574\uc2dc \ubc84\ud0b7\uc774\ub77c\uace0 \ud558\ub294 hash\ub9f5\uc744 \uac16\uace0\uc11c \uc774 \ubc84\ud37c\uce90\uc2dc\uc758 \ube14\ub85d\uc744 &#8216;\uc5b4\ub5bb\uac8c \ube60\ub974\uac8c \ucc3e\ub290\ub0d0&#8217; \uc5d0 \ub300\ud55c \uba54\ud0c0\uc815\ubcf4\ub97c \ub2f4\uace0\uc788\ub294 \ubc84\ud37c\ud5e4\ub354\ub3c4 \uac19\uc774 \uc6b4\uc6a9\ud55c\ub2e4. \uc774\uac83\uc774 \ubc84\ud37c\uce90\uc2dc \ub0b4\uc758 \ubc84\ud37c\ud5e4\ub354\ub77c\uace0 \ud558\uace0&#8230;. \uc774 \ud5e4\ub354\ub97c \uc798 \uc6b4\uc6a9\ud568\uc73c\ub85c\uc368 \uc791\uc740 \uc2dc\uac04\ubcf5\uc7a1\ub3c4\ub85c \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\uc774 \uac00\ub2a5\ud558\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">03 \ubc84\ud37c Lock<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ubd80\ubd84\uc740 \uc0ac\uc2e4 \uc774\ud574\uac00 \uc798 \uc548\uac14&#8230;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\ub824\uba74, \ubc84\ud37c\uce90\uc2dc\uc5d0 \uc811\uadfc\ud558\ub294 user\uac00 \ub798\uce58\ub97c \uc810\uc720\ud558\uace0 \ud574\uc81c\ud574\uc57c \ud558\ub294\ub370, \uadf8\ub584 \uc774 \ubc84\ud37c lock\uc5d0 \ub300\ud55c \uc124\uba85\uc774 \ub4e4\uc5b4\uac00 \uc788\uc74c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub584\uc758 \ubc84\ud37c lock\uc744 \ub2e4\ub978\ub9d0\ub85c &#8216;\ubc84\ud37c Pin&#8217;\uc774\ub77c\uace0 \ud558\ub294\ub370&#8230;.. \uc77c\ub2e8 \ub09c \ucc98\uc74c \ub4e4\uc5b4\ubd04&#8230;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc84\ud37c\uce90\uc2dc\uc5d0 \uac12\uc744 \uc4f0\uae30 \ud560 \ub54c\uc5d0\ub294 \ub2f9\uc5f0\ud788 1user 1lock\uc774\ub098, \uc77d\uae30 \ub3d9\uc791\uc740 \uc5ec\ub7ec\uba85\uc758 user\uac00 lock\uc744 \ud68d\ub4dd\ud560 \uc218 \uc788\ub2e4\uace0 \ud558\ub294 \uc774\uc57c\uae30\ub3c4 \ub098\uc624\uace0&#8230;.. \ud574\ub2f9 \ucc55\ud130\uc5d0\uc11c\ub294 \uadf8\ub0e5 \ud06c\uac8c \uc911\uc694\ud55c \ud0a4\uc6cc\ub4dc\ub098 \uac1c\ub150\/\uba54\ucee4\ub2c8\uc998\uc740 \ub098\uc624\uc9c0 \uc54a\uc740 \ub4ef \ud558\uc5ec, \uadf8\ub0e5 \uc2a5\uc2a5 \uc77d\uace0 \ub118\uc5b4\uac10<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">04 Redo<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc624\ub77c\ud074\uc740, \uae30\ubcf8\uc801\uc73c\ub85c \ubc84\ud37c \uce90\uc2dc\ub3c4 \ub450\uace0, \uc2e4 DML\ucc98\ub9ac\ub97c \ub514\uc2a4\ud06c\uc5d0 \uc4f0\ub294\uac83\ub3c4 \ubc84\ud37c\ub9c1\uc744 \ub450\uc5b4 \ub3d9\uc791\ud558\uae30\uc5d0, \ub9cc\uc5d0 \ud558\ub098&#8230;.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DML\ucc98\ub9ac\uac00 \ub41c \uc0ac\ud56d\ub4e4\uc774 \ucd5c\uc885 \ub514\uc2a4\ud06c\uc5d0 write\ub418\uc9c0 \uc54a\uc558\uc744 \uc2dc \ub370\uc774\ud130 \uc720\uc2e4<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ub418\ub294 \uad6c\uc870\ub85c \uc6b4\uc601\ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc, DBMS\uc758 \uc2e0\ub8b0\uc131\uc5d0 \uc788\uc5b4\uc11c \uc774\uac74 \uc6a9\ub0a9\ud560 \uc218 \uc5c6\uae30\uc5d0 Redo\ub77c\ub294 \uc2a4\ud399\uc774 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uc77c\ub828\uc758 \ub370\uc774\ud130 write\ub97c, Redo\ub85c\uadf8\ud30c\uc77c\uc5d0 \ub85c\uadf8\ub97c \uc313\ub294 \ubc29\uc2dd\uc73c\ub85c \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\uace0 \uc788\uc73c\uba70, \ub2f9\uc5f0\ud788 \ub85c\uadf8 \ub370\uc774\ud130\ub294 \ud55c\uc815\uc801\uc774\uae30\uc5d0 \ub77c\uc6b4\ub4dc \ub85c\ube48 \ubc29\uc2dd\uc73c\ub85c \uc774 redo\ub97c \uad00\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>DB recovery<\/li><li>Cache recovery<\/li><li>Fast Commit<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uc138\uac00\uc9c0\uc758 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud558\uae30 \uc704\ud574 Redo\ub85c\uadf8\ub97c \uc0ac\uc6a9\ud55c\ub2e4\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>DB recovery, Cache recovery<ul><li>\ub2f9\uc5f0\ud788 \uadf8\ub798\uc11c\ub294 \uc548\ub418\uaca0\uc9c0\ub9cc, DB fail\uc2dc\uc5d0 (\uc804\uc6d0\uc774 \ub098\uac14\ub2e4\ub358\uac00..) \uc774\uc804\uc5d0 \uc791\uc5c5\ud558\uace0 \ubbf8\ucc98 \uc2e4 \ub370\uc774\ud130\uc5d0 \ucd5c\uc885 write \uac00 \ub418\uc9c0 \uc54a\uc740 \uc601\uc5ed\uc744 \ub9ac\ucee4\ubc84\ub9ac \ud558\uae30 \uc704\ud568<\/li><\/ul><\/li><li>Fast Commit<ul><li>\uc55e\uc120 DB recovery, cache recovery\ub791 \uc77c\ub9e5\uc0c1\ud1b5\ud558\ub294 \uac1c\ub150\uc778\ub370&#8230; &#8216;\uc2e4 \ub370\uc774\ud130\uc5d0 \ucd5c\uc885 write\uac00 \ub420 \ub54c\uae4c\uc9c0&#8217; \ucee4\ubc0b \uc644\ub8cc \uc5ec\ubd80\ub97c \uae30\ub2e4\ub9ac\uae30\uc5d4 \uc5c4~~~~~~~\uccad\ub09c \uc131\ub2a5 \uc800\ud558\uac00 \uc624\uae30\uc5d0, redo \ub85c\uadf8\ub97c \ud1b5\ud574\uc11c \ucee4\ubc0b\uc744 \ucd5c\ub300\ud55c \ube68\ub9ac \uc885\ub8cc\ud560 \uc218 \uc788\uac8c \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud574 \uc900\ub2e4.\u314e\u314e<\/li><\/ul><\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">p.s : \ubc11\uc5d0\uc11c \uc774\uc57c\uae30 \ud560 Undo\uc640 \ud568\uaed8 \uaf64 \uc911\uc694\ud55c \uac1c\ub150&#8230;. \uc0ac\uc2e4 DB fail \uc774\ud6c4 \ubcf5\uad6c\ud560\ub54c Redo\ub9cc\uc73c\ub85c\ub294 \uc644\uc804 \ubcf5\uad6c\uac00 \uc548\ub41c\ub2e4. Undo\ub3c4 \uac19\uc774 \uc788\uc5b4\uc57c \ud568..<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">05 Undo<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">&#8216;\ub864\ubc31&#8217;\uc774\ub77c\ub294 \uc6a9\uc5b4\uc640 \ub3d9\uc77c\ud558\uac8c \uc0dd\uac01\ud558\uba74 \ub41c\ub2e4. (\uc2e4\uc81c\ub85c DML\uc798\ubabb\ub54c\ub9ac\uace0 \ucf58\uc194\uc5d0 ROLLBACK; \uba85\ub839\uc5b4 \uce60\ub54c, \uc774 Undo\uc138\uadf8\uba3c\ud2b8\ub97c \ubcf4\uace0 \ub864\ubc31\ud568.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac70\ub450\uc808\ubbf8\ud558\uace0&#8230; \uadf8\ub0e5 \ubcf8\ub860\ubd80\ud130&#8230;<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>\ud2b8\ub79c\uc7ad\uc158 \ub864\ubc31<\/li><li>\ud2b8\ub79c\uc7ad\uc158 \ub9ac\ucee4\ubc84\ub9ac<\/li><li>\uc77d\uae30 \uc77c\uad00\uc131<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\uccab\uc9f8,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ub2e8 \ud2b8\ub79c\uc7ad\uc158 \ub864\ubc31\/DB fail\uc774\ud6c4 \ubcf5\uad6c\uc2dc\uc5d0 \uc6b0\uc120 Redo\ub97c \ud1b5\ud574 \ub9ac\ucee4\ubc84\ub9ac\ub97c \ud558\uba74, \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\ucd5c\uc885\uc801\uc73c\ub85c \ucee4\ubc0b \uc548\ucc0d\uc740 \uc560\ub4e4\uae4c\uc9c0 \ubcf5\uad6c\ub428<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">&#8230;&#8230;. \uace0\ub7f4\ub584 \uc774\uc81c \ucee4\ubc0b\ub418\uc9c0 \uc54a\uc740 \ub0b4\uc6a9\ub4e4\uc744 \ub864\ubc31\ud558\ub294\ub370, \uc774\ub54c \uc774 Undo\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub458\uc9f8,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Undo\ub370\uc774\ud130\ub294 \uc77d\uae30 \uc77c\uad00\uc131\uc744 \uc704\ud574 \uc0ac\uc6a9\ud558\ub294\ub370, &#8216;\ub0b4\uac00 \uc77d\uc740 \uc2dc\uc810\uc5d0 \ub2e4\ub978 user\uac00 \uc774\ubbf8 DML\uc744 \uccd0 \ubc84\ub9b0 \uc0c1\ud669&#8217; \ub4f1\uc5d0\uc11c \uc774 Undo\ub97c \ub9e4\uc6b0 \uc694\uae34\ud558\uac8c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub0b4\uac00 \uc0dd\uac01\ud588\uc744\ub588 \uc774 Undo\ub97c \ud1b5\ud55c \uc77d\uae30 \uc77c\uad00\uc131 \ub355\ubd84\uc5d0, \uc624\ub77c\ud074\uc774 &#8216;\uc131\ub2a5\uc774 \uc88b\ub2e4&#8217; \ub77c\ub294 \ucde8\uae09\uc744 \ubc1b\ub294\uac70 \uc544\ub2cc\uac00 \uc2f6\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\ud0c0 DB\ub4e4\uc740 \uadf8\ub0e5 \uc77d\uc744\ub54c\uc5d0\ub3c4 \ub2e4\ub978 user\uac00 write\ub97c \ubabb\ud558\uac8c lock\uc744 \uac80&#8230;.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5b4\ucc28\ud53c \ub2e4\uc74c \ucc55\ud130\uc5d0\uc11c \uc624\ub77c\ud074\uc774 \uc77d\uae30 \uc77c\uad00\uc131\uc744 \uc5b4\ub5bb\uac8c \uc720\uc9c0\ud558\ub294\uc9c0 \uc798 \uc124\uba85\uc774 \ub41c\ub2e4. \uc774 \ubd80\ubd84\uc740 \uc815\ub3c5\ud558\uc790&#8230;\u314b\u314b<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub9ac\uace0 \ud2b8\ub79c\uc7ad\uc158 \ud14c\uc774\ube14 \uc2ac\ub86f\uc774\ub780 \uad6c\uc870\ub97c \ud1b5\ud558\uc5ec, \uc774 Undo\uc138\uadf8\uba3c\ud2b8\ub97c \uad00\ub9ac\ud55c\ub2e4\ub294 \uc124\uba85\ub4e4\ub3c4 \ub108\uc904\ub108\uc904 \uc788\uae34 \ud55c\ub370&#8230;.\uc774\ud574\ub97c \uc798 \ubabb\ud588\ub2e4&#8230; DBA \uad00\uc810\uc73c\ub85c \uae4a\uac8c \uc54c\uc544\ub450\uace0 \uc2f6\uc744\ub584 \uc77d\uc5b4\uc57c\uaca0\ub2e4&#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\"><\/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\"><\/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>01 \uae30\ubcf8 \uc544\ud0a4\ud14d\uccd0 DBA\uac00 \uc544\ub2cc \uc774\uc0c1 \uadf8\ub807\uac8c \uc911\uc694\ud55c \uc6a9\uc5b4 \ubc0f \uac1c\ub150\uc774 \uc788\uc5b4\ubcf4\uc774\uc9c4 \uc54a\ub294\ub2e4. \uc911\uac04\uc5d0 &#8216;\ub514\uc2a4\ud06c \uc561\uc138\uc2a4 \uc554&#8217; \uc774\uc57c\uae30\uac00 \ub098\uc624\uae30\ub3c4 \ud558\uace0&#8230;. \ud559\ubd80\uc2dc\uc808 \uac1c\ub860 \uc218\uc900\uc73c\ub85c \uc774\uc57c\uae30 \ub418\ub294 Multi User One Resource\uac1c\ub150\uc744 \ud6d1\uace0 \ub118\uc5b4\uac00\ub294 \uc815\ub3c4\ub77c\uc11c \ub300\uac1c\ub294 \uc0dd\ub7b5\ud574\ub3c4 \ub428. \ud558\uc9c0\ub9cc \uc911\uc694\ud55c \ud575\uc2ec \ud0a4\uc6cc\ub4dc \uba87\uac1c\ub294 \uc874\uc7ac. \uc774 \ubd80\ubd84\ub9cc \uc9da\uace0 \uac04\ub2e4. Latch SGA (System Global Area) multi user\uc758 \ud2b9\uc9d5\uc778, \uacbd\ud569 \uc0c1\ud0dc\uc5d0\uc11c\uc758 &#8230; <a title=\"\uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\uc640 \ud574\ubc95 (Ch.1 1~5)\" class=\"read-more\" href=\"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/2024\/06\/10\/%e3%85%85%e3%84%b7%e3%84%b4%e3%85%85\/\" aria-label=\"Read more about \uc624\ub77c\ud074 \uc131\ub2a5 \uace0\ub3c4\ud654 \uc6d0\ub9ac\uc640 \ud574\ubc95 (Ch.1 1~5)\">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-1074","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\/1074","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=1074"}],"version-history":[{"count":7,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1074\/revisions"}],"predecessor-version":[{"id":1095,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1074\/revisions\/1095"}],"wp:attachment":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=1074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=1074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=1074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}