{"id":413,"date":"2025-01-22T17:22:45","date_gmt":"2025-01-22T08:22:45","guid":{"rendered":"https:\/\/sejiwon.com\/?p=413"},"modified":"2025-01-22T17:22:45","modified_gmt":"2025-01-22T08:22:45","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8b%a8%ed%8e%b8%ed%99%94","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=413","title":{"rendered":"\uc624\ub77c\ud074 \ub2e8\ud3b8\ud654"},"content":{"rendered":"\n<p>\uc624\ub77c\ud074\uc5d0\uc11c \ub2e8\ud3b8\ud654(Fragmentation)\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\ub294 \uc911\uc694\ud55c \ubb38\uc81c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub2e8\ud3b8\ud654\ub294 \ub370\uc774\ud130\uac00 \ubb3c\ub9ac\uc801\uc73c\ub85c \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc800\uc7a5\ub418\uc5b4, \ub514\uc2a4\ud06c I\/O\uac00 \uc99d\uac00\ud558\uac70\ub098 \ucffc\ub9ac \uc131\ub2a5\uc774 \uc800\ud558\ub418\ub294 \uc0c1\ud669\uc744 \ub9d0\ud569\ub2c8\ub2e4. \uc624\ub77c\ud074\uc5d0\uc11c\ub294 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \ub2e8\ud3b8\ud654\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4: <strong>\ud14c\uc774\ube14 \ub2e8\ud3b8\ud654<\/strong>\uc640 <strong>\uc778\ub371\uc2a4 \ub2e8\ud3b8\ud654<\/strong>.<\/p>\n\n\n\n<ol>\n<li><strong>\ud14c\uc774\ube14 \ub2e8\ud3b8\ud654 (Table Fragmentation)<\/strong><br>\ud14c\uc774\ube14 \ub2e8\ud3b8\ud654\ub294 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130\uac00 \uc0bd\uc785, \uc0ad\uc81c \ub610\ub294 \uc5c5\ub370\uc774\ud2b8\ub418\uba74\uc11c \ub370\uc774\ud130\uac00 \ubb3c\ub9ac\uc801\uc73c\ub85c \ubd84\uc0b0\ub418\uc5b4 \uc800\uc7a5\ub420 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774\ub85c \uc778\ud574 \ub514\uc2a4\ud06c \uacf5\uac04\uc774 \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\uac70\ub098, \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<ul>\n<li><strong>\uc6d0\uc778<\/strong>:\n<ul>\n<li>\ub300\ub7c9\uc758 \uc0bd\uc785, \uc0ad\uc81c, \uac31\uc2e0 \uc791\uc5c5<\/li>\n\n\n\n<li>\ube48\ubc88\ud55c \ub370\uc774\ud130 \ubcc0\uacbd<\/li>\n\n\n\n<li>\ud14c\uc774\ube14\uc758 \ud06c\uae30\uac00 \ubcc0\ub3d9\ub418\uba74\uc11c \ub370\uc774\ud130\ub97c \uc7ac\uc815\ub82c\ud558\uc9c0 \uc54a\uc74c<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ud574\uacb0 \ubc29\ubc95<\/strong>:\n<ul>\n<li><code>ALTER TABLE &lt;\ud14c\uc774\ube14\uba85&gt; MOVE<\/code> \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc744 \uc7ac\uad6c\uc131\ud558\uac70\ub098, \ud30c\ud2f0\uc154\ub2dd\uc744 \uace0\ub824\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>DBMS_REDEFINITION<\/code> \ud328\ud0a4\uc9c0\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc628\ub77c\uc778\uc73c\ub85c \ud14c\uc774\ube14\uc744 \uc7ac\uad6c\uc131\ud558\ub294 \ubc29\ubc95\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\uc778\ub371\uc2a4 \ub2e8\ud3b8\ud654 (Index Fragmentation)<\/strong><br>\uc778\ub371\uc2a4 \ub2e8\ud3b8\ud654\ub294 \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub418\uba74\uc11c \uc778\ub371\uc2a4\uc758 \uad6c\uc870\uac00 \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc800\uc7a5\ub418\ub294 \ud604\uc0c1\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4 \ub2e8\ud3b8\ud654\uac00 \uc2ec\ud574\uc9c0\uba74 \uc778\ub371\uc2a4\ub97c \uac80\uc0c9\ud558\ub294 \ub370 \uc2dc\uac04\uc774 \ub354 \uac78\ub9ac\uace0, \ub514\uc2a4\ud06c I\/O\uac00 \uc99d\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<ul>\n<li><strong>\uc6d0\uc778<\/strong>:\n<ul>\n<li>\ube48\ubc88\ud55c \uc0bd\uc785, \uc0ad\uc81c \ubc0f \uc5c5\ub370\uc774\ud2b8 \uc791\uc5c5\uc73c\ub85c \uc778\ud574 \uc778\ub371\uc2a4\uc758 \uade0\ud615\uc774 \uae68\uc9d0<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ud574\uacb0 \ubc29\ubc95<\/strong>:\n<ul>\n<li><code>ALTER INDEX &lt;\uc778\ub371\uc2a4\uba85&gt; REBUILD<\/code> \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4\ub97c \uc7ac\uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>REORG<\/code> \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud574 \uc778\ub371\uc2a4\ub97c \ub2e4\uc2dc \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc778\ub371\uc2a4\uc758 **\ud799 \uc870\uc815(Heap Adjustment)**\ub3c4 \uace0\ub824\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">\ub2e8\ud3b8\ud654 \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub3c4\uad6c\uc640 \uae30\ubc95<\/h3>\n\n\n\n<ul>\n<li><strong>Auto Segment Space Management<\/strong>: \uc624\ub77c\ud074\uc740 **ASSM (Automatic Segment Space Management)**\ub97c \uc9c0\uc6d0\ud558\uc5ec, \uacf5\uac04\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ub2e8\ud3b8\ud654\ub97c \uc904\uc774\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>Tablespace \uad00\ub9ac<\/strong>: \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uc0ac\uc6a9\uc744 \uc8fc\uae30\uc801\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \uc7ac\uad6c\uc131\ud558\ub294 \ubc29\ubc95\ub3c4 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>Oracle\uc758 DBA \ub3c4\uad6c<\/strong>: <code>DBMS_SPACE<\/code> \ubc0f <code>DBMS_STATS<\/code> \ub4f1\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uacfc \uc778\ub371\uc2a4\uc758 \uc0c1\ud0dc\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0, \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uc704\ud55c \uc801\uc808\ud55c \uc870\uce58\ub97c \ucde8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\ub2e8\ud3b8\ud654 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub824\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ubfd0\ub9cc \uc544\ub2c8\ub77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\uc9c0\ubcf4\uc218 \uc791\uc5c5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ubaa8\ub2c8\ud130\ub9c1\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub77c\ud074\uc5d0\uc11c \ub2e8\ud3b8\ud654(Fragmentation)\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\ub294 \uc911\uc694\ud55c \ubb38\uc81c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub2e8\ud3b8\ud654\ub294 \ub370\uc774\ud130\uac00 \ubb3c\ub9ac\uc801\uc73c\ub85c \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc800\uc7a5\ub418\uc5b4, \ub514\uc2a4\ud06c I\/O\uac00 \uc99d\uac00\ud558\uac70\ub098 \ucffc\ub9ac \uc131\ub2a5\uc774 \uc800\ud558\ub418\ub294 \uc0c1\ud669\uc744 \ub9d0\ud569\ub2c8\ub2e4. \uc624\ub77c\ud074\uc5d0\uc11c\ub294 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \ub2e8\ud3b8\ud654\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4: \ud14c\uc774\ube14 \ub2e8\ud3b8\ud654\uc640 \uc778\ub371\uc2a4 \ub2e8\ud3b8\ud654. \ub2e8\ud3b8\ud654 \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub3c4\uad6c\uc640 \uae30\ubc95 \ub2e8\ud3b8\ud654 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub824\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ubfd0\ub9cc \uc544\ub2c8\ub77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\uc9c0\ubcf4\uc218 \uc791\uc5c5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ubaa8\ub2c8\ud130\ub9c1\ud558\ub294 \uac83\uc774\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=413\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/413"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=413"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/413\/revisions"}],"predecessor-version":[{"id":414,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/413\/revisions\/414"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}