{"id":3431,"date":"2018-02-04T18:59:08","date_gmt":"2018-02-04T09:59:08","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3431"},"modified":"2018-02-04T18:59:08","modified_gmt":"2018-02-04T09:59:08","slug":"oracle-table-%ec%95%95%ec%b6%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3431","title":{"rendered":"Oracle Table \uc555\ucd95"},"content":{"rendered":"<p>\uc9c0\ub09c 10 \ub144 \ub3d9\uc548 \uae30\uc5c5\uc5d0\uc11c \ub2e4\ub8e8\uc5b4\uc9c0\ub294 \uace0\uac1d\ub370\uc774\ud130\uc640 \uc601\uc5c5\ud65c\ub3d9 \ubc0f \uac70\ub798\ub85c\ubd80\ud130 \ubc1c\uc0dd\ud55c \ub370\uc774\ud130\ub294 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \uc99d\uac00\ud574\uc654\ub2e4.<\/p>\n<p>\ucd5c\uadfc\uc5d0\ub294 \uae30\uc5c5 \ub370\uc774\ud130\uc758 \uc601\uc5ed\uc774 \uae30\uc874\uc758 \uc815\ud615 \ub370\uc774\ud130\uc5d0\uc11c \ube44\uc815\ud615 \ub370\uc774\ud130\ub85c\uae4c\uc9c0 \ud655\ub300\ub418\uace0 \uc788\uc5b4\uc11c \uadf8 \uc99d\uac00\uc758 \uc18d\ub3c4\ub294 \ub354\uc6b1 \ube68\ub77c\uc9c0\uace0 \uc788\ub2e4.<\/p>\n<p>Winter Corp\uc5d0\uc11c \ubc1c\ud45c\ud558\ub294 \uae30\uc5c5 \uc804\uc0b0 \uc2dc\uc2a4\ud15c\uc758 \ub370\uc774\ud130 \uc0ac\uc774\uc988 \ud1b5\uacc4\uc5d0 \ub530\ub974\uba74, 2003\ub144\uc5d0\ub294 30TB\uc758 FT(France Telecom)\uc774 \uac00\uc7a5 \ud070 \uaddc\ubaa8\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc600\uace0,<\/p>\n<p>2005\ub144\uc5d0\ub294 Yahoo\uc758 100TB, 2006\ub144 \ub9d0\uc5d0\ub294 \ud638\uc8fc\uc5d0\uc11c 150TB\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad6c\ucd95\ud588\uc73c\uba70, \ucd5c\uadfc\uc5d0\ub294 \uad6d\ub0b4\uc5d0\uc11c\ub3c4 \ube44\uc2b7\ud558\uac70\ub098 \uadf8 \uc774\uc0c1\uc758 \uaddc\ubaa8\ub97c \uac00\uc9c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uad6c\ucd95\ub418\uace0 \uc788\ub2e4.<\/p>\n<p>\uc774 \uac19\uc740 \ub370\uc774\ud130\uc758 \ud3ed\ubc1c\uc801\uc778 \uc99d\uac00 \ud604\uc0c1\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uc694\uc778\ub4e4\ub85c \ub354\uc6b1 \uac00\uc18d\ub418\uace0 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&#8211; \ub9ce\uc740 \uc591\uc758 \uc815\ubcf4(History data)\ub97c \uc7a5\uae30\uac04 \ubcf4\uad00\ud558\ub3c4\ub85d \uc694\uad6c\ud558\ub294 SOX\ub098 HIPPA\uc640 \uac19\uc740 \uaddc\ubc94\ub4e4<\/p>\n<p>&#8211; Broadband \uae30\uc220\uc758 \ubc1c\uc804\uc73c\ub85c \uc778\ud130\ub137\uc5d0 \ubd84\uc0b0\ub41c rich &amp; multimedia contents<\/p>\n<p>&#8211; Web 2.0\uc758 \ub4f1\uc7a5\uc73c\ub85c \uc778\ud55c UCC(User Created Contents)<\/p>\n<p>&nbsp;<\/p>\n<p>\uc804\uc0b0 \uc2dc\uc2a4\ud15c\uc758 \ud658\uacbd\uc774 \uc774\ub7ec\ud558\ub2e4\ubcf4\ub2c8, IT\uad00\ub9ac\uc790\ub4e4\uc740 \ud3ed\uc99d\ud558\ub294 \ub370\uc774\ud130\ub97c \uc81c\ub300\ub85c \uad00\ub9ac\ud574\uc57c \ud55c\ub2e4\ub294 \uc5b4\ub824\uc6b4 \ub2f9\uba74 \uacfc\uc81c\uc5d0 \ubd09\ucc29\ud574 \uc788\ub2e4.<\/p>\n<p>\uccab\ubc88 \uc9f8\ub85c \uc5b4\ub824\uc6b4 \ubb38\uc81c\ub294 \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \ud22c\uc785\ub418\ub294 \ube44\uc6a9\uc774 \uc810\uc810 \ub354 \uc99d\uac00\ud558\uace0 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4. MB \ub2f9 \ube44\uc6a9\uc740 \ud070 \ud3ed\uc73c\ub85c \ub5a8\uc5b4\uc84c\uc9c0\ub9cc, online\uc73c\ub85c \uc720\uc9c0\ud574\uc57c \ud558\ub294 \uc804\uccb4 \ub370\uc774\ud130\uc758 \uc591\uc774 \ud3ed\ubc1c\uc801\uc73c\ub85c \uc99d\uac00\ud568\uc73c\ub85c\uc368, \uc5ec\uc804\ud788 \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \ud544\uc694\ud55c \uc608\uc0b0\uc774 \uc804\uccb4 IT \uc608\uc0b0\uc5d0\uc11c \uac00\uc7a5 \ud070 \ubd80\ubd84\uc744 \ucc28\uc9c0\ud558\uace0 \uc788\ub294 \uac83\uc774\ub2e4. \ucd94\uac00\uc801\uc73c\ub85c, \ub370\uc774\ud130 \ud06c\uae30\uac00 \ud3ed\uc99d\ud558\ub294 \ud55c\uc774 \uc788\ub354\ub77c\ub3c4, \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud655\uc7a5\uc131\uc774\ub098 \uac00\uc6a9\uc131 \ubc0f \uc131\ub2a5\uc740 \ube44\uc988\ub2c8\uc2a4\uac00 \uc694\uad6c\ud558\ub294 \uc218\uc900\uc744 \uacc4\uc18d\ud574\uc11c \uc720\uc9c0\ud574\uc57c\ub9cc \ud558\ub294 \ub610 \ub2e4\ub978 \uacfc\uc81c\uc744 \ub358\uc838\uc8fc\uace0 \uc788\ub2e4.<\/p>\n<p>Oracle Database 11g \uc758 Advanced Compression Option\uc740 \uc774\uc640 \uac19\uc740 \uacfc\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ud3ec\uad04\uc801\uc778 \uae30\uc220\ub4e4\uc744 \uc218\uc6a9\ud558\uace0 \uc788\ub2e4.<\/p>\n<p>Oracle11g\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc218 \ub9ce\uc740 \ud601\uc2e0\uc801\uc778 \uae30\uc220\ub4e4\uc744 \ud65c\uc6a9\ud558\uc5ec, \uace0\uac1d\uc740 \uc5b4\ub5a4 \ud615\ud0dc\uc758 \ub370\uc774\ud130\ub77c\uace0 \ud574\ub3c4 \uc27d\uac8c \uc555\ucd95\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>\uc77c\ubc18\uc801\uc778 \uc815\ud615 \ub370\uc774\ud130\ub098 \ubb38\uc11c, \uc774\ubbf8\uc9c0, \uba40\ud2f0\ubbf8\ub514\uc5b4 \ub4f1\uc758 \ube44\uc815\ud615 \ub370\uc774\ud130, \uadf8\ub9ac\uace0 \ubc31\uc5c5 \ubc1b\uc740 \ub370\uc774\ud130\uae4c\uc9c0\ub3c4 \uc555\ucd95\ud558\uc5ec \ubcf4\uad00\ud560 \uc218 \uc788\uc73c\uba70, \ub124\ud2b8\uc6cc\ud06c \ud1b5\uc2e0\uc5d0\uc11c\ub3c4 \uc555\ucd95\uc744 \uc9c0\uc6d0\ud55c\ub2e4.<\/p>\n<p>\uc774 \uac19\uc740 \uc555\ucd95 \uae30\uc220\uc740 \uc790\uc6d0 \uc0ac\uc6a9\uc728\uc758 \ud6a8\uc728\uc131\uc744 \uadf9\ub300\ud654\uc2dc\ud0a4\uba70 \uc804\uccb4 \uc790\uc6d0\uc758 \uc694\uad6c\ub7c9\uacfc \ube44\uc6a9\uc744 \uc904\uc5ec\uc8fc\uac8c \ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>Compression Algorithm<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image0-2.png\"><img loading=\"lazy\" style=\"margin: 0px; display: inline; background-image: none;\" title=\"image0\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image0_thumb-2.png?resize=244%2C5\" alt=\"image0\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>\uc624\ub77c\ud074\uc740 9i\ubd80\ud130 11g\uae4c\uc9c0 relational data\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \ud2b9\ud654\ub41c \uc54c\uace0\ub9ac\uc998\uc744 \uc0ac\uc6a9\ud55c\ub2e4. \uc774 \uc54c\uace0\ub9ac\uc998\uc740 database block \ub0b4, \ub2e4\uc218\uc758 column\uae4c\uc9c0\ub3c4 \uc911\ubcf5\ub41c \uac12\uc744 \uc81c\uac70\ud568\uc73c\ub85c\uc368 compression\uc744 \uc218\ud589\ud55c\ub2e4.<\/p>\n<p><strong>Compress \ub41c block\uc740 compression\uacfc \uad00\ub828\ub41c metadata\ub97c symbol table\uc5d0 \uc800\uc7a5\ud55c\ub2e4. <\/strong><\/p>\n<p>\uc774 table\ub294 block\uc758 \uc0c1\ub2e8\uc5d0 \uc704\uce58\ud574 \uc788\ub2e4. Symbol table\uc774 \uac01 block\uc5d0 \uc788\ub2e4\ub294 \uc810\ub9cc \uc81c\uc678\ud558\uba74 uncompressed table\uacfc compressed table\uc758 \ucc28\uc774\ub294 \uac70\uc758 \uc5c6\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image1-1.png\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"image1\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image1_thumb-1.png?resize=557%2C451\" alt=\"image1\" width=\"557\" height=\"451\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Benefits of Table Compression<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image2.png\"><img loading=\"lazy\" style=\"margin: 0px; display: inline; background-image: none;\" title=\"image2\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image2_thumb.png?resize=244%2C5\" alt=\"image2\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>1.)\u00a0 \uc77c\ubc18\uc801\uc73c\ub85c table compression \uae30\ub2a5\uc744 \ud1b5\ud574 storage \uacf5\uac04\uc744 2~3\ubc30 \uc904\uc77c \uc218 \uc788\ub2e4.<\/p>\n<p>2.)\u00a0 Block\uc744 uncompress\ud558\uc9c0 \uc54a\uace0\ub3c4 \ubc14\ub85c read\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>\u2192 \uc624\ud788\ub824, access\ud558\ub294 block \uc218\uac00 \uc904\uae30 \ub54c\ubb38\uc5d0 I\/O\ub97c \uac10\uc18c\uc2dc\ucf1c performance\uac00 \uc88b\uc544\uc9c8 \uc218 \uc788\ub2e4.<\/p>\n<p>3.)\u00a0 Block \uc218\uac00 \uac10\uc18c\ud55c \ub9cc\ud07c buffer cache\ub97c \ub354 \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image3.png\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"image3\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image3_thumb.png?resize=582%2C421\" alt=\"image3\" width=\"582\" height=\"421\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>How to use Compression<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image4-2.png\"><img loading=\"lazy\" style=\"margin: 0px; display: inline; background-image: none;\" title=\"image4\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image4_thumb-2.png?resize=244%2C5\" alt=\"image4\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>\u201e CREATE TABLE &lt;table_name&gt; (\u2026) COMPRESS;<\/p>\n<p>= CREATE TABLE &lt;table_name&gt; (\u2026) COMPRESS FOR DIRECT_LOAD OPERATIONS;<\/p>\n<p>\u2192 direct-path insert\ub97c \ud560 \ub54c\ub9cc compress\ub41c\ub2e4.(9i\uc640 10g\uc5d0\uc11c \uc0ac\uc6a9\ud55c \ubc29\ubc95)<\/p>\n<p>&nbsp;<\/p>\n<p>\u201e CREATE TABLE &lt;table_name&gt; (\u2026) COMPRESS FOR ALL OPERATIONS<\/p>\n<p>\u2192 direct-path insert\ubfd0\ub9cc \uc544\ub2c8\ub77c \ubaa8\ub4e0 DML\uc774 \uc801\uc6a9\ub41c\ub2e4. OLTP\ud658\uacbd\uc5d0 \uc0ac\uc6a9\ud55c\ub2e4. (11g)<\/p>\n<p>&nbsp;<\/p>\n<p>\u201e ALTER TABLE &lt;table_name&gt; (\u2026) COMPRESS<\/p>\n<p>\u2192 \uc774\ud6c4 data\ubd80\ud130 compress\ud558\uae30 \uc2dc\uc791\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\u201e ALTER TABLE &lt;table_name&gt; (\u2026) NOCOMPRESS<\/p>\n<p>\u2192 \uc774\ud6c4 data\ubd80\ud130 uncompress\ub41c \uc0c1\ud0dc\ub85c insert \ub610\ub294 update\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Compression of Partitioned Tables<\/strong><\/p>\n<p>\u201e Table\uc5d0 \uc815\uc758\ub41c compression \uc18d\uc131\uacfc \uac01 Partition\uc758 \uc18d\uc131\uc774 \ub2e4\ub974\uba74 Partition\uc758 \uc18d\uc131\uc774 \uc6b0\uc120\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00a0To determine if a Table is Compressed<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image6.png\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"image6\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image6_thumb.png?resize=244%2C5\" alt=\"image6\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>\u201e *_TABLES\uc758 COMPRESSION column\uc744 \ud655\uc778\ud55c\ub2e4.<\/p>\n<p>\u201e For Partitioned tables: *_TAB_PARTITIONS\uc758 COMPRESSION column\uc744 \ud655\uc778\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>New Feature<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>10g\uc758 Table Compression<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image7-1.png\"><img loading=\"lazy\" style=\"margin: 0px; display: inline; background-image: none;\" title=\"image7\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image7_thumb-1.png?resize=244%2C5\" alt=\"image7\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>\u201e Compression \uc2dc\uae30<\/p>\n<p>\uc0c8\ub85c\uc6b4 data\ub97c Bulk insert\ub098 bulk load\ud560 \ub54c compression\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>\u2192 batch process\ub85c data\ub97c load\ud558\ub294 DW\uc5d0 \uc774\uc0c1\uc801\uc774\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Direct path SQL*Loader<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; CREATE TABLE AS SELECT (CTAS) statements<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Parallel INSERT (or serial INSERT with an APPEND hint) statements<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\uae30\uc874\uc758 data\ub294 ALTER TABLE\uacfc MOVE statement\ub85c compress\ud560 \uc218 \uc788\ub2e4. \uc774 \uacfc\uc815\uc5d0\ub294 exclusive lock\uc774 \uc0ac\uc6a9\ub418\uba70 \uc5b4\ub5a0\ud55c update\ub098 load\ub97c \ubc29\uc9c0\ud55c\ub2e4. \uc774\uac83\uc774 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\ub294\ub2e4\uba74 redefinition utility (DBMS_REDEFINITION PL\/SQL package)\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\u201e Note<\/p>\n<p>Compression\uacfc \uad00\ub828\ub41c overhead\ub294 bulk loading \uc911\uc5d0 \ucd5c\ub300\uac00 \ub41c\ub2e4. \ub610\ud55c, Compress\ub41c table\uc5d0 DML\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc bulk insertion\uc774\ub098 bulk loading\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc740 data\ub294 compress\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n<p>\uacb0\uad6d \ud55c table\uc548\uc5d0 compress\ub41c \ubd80\ubd84\uacfc uncompress\ub41c \ubd80\ubd84\uc774 \uacf5\uc874\ud558\uac8c \ub41c\ub2e4. Uncompressed table\uacfc \ube44\uad50\ud574\uc11c\ub294 Update\uc744 \uc81c\uc678\ud55c \ub2e4\ub978 DML\uc5d0\uc11c\ub294 \ucc98\ub9ac\uc18d\ub3c4\uc0c1\uc758 \ucc28\uc774\uac00 \uac70\uc758 \uc5c6\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>* OLTP \ubcf4\ub2e4 DW\uc5d0 \uc720\ub9ac\ud558\ub2e4.<\/p>\n<p>* Enterprise Edition\uc5d0 \ud3ec\ud568.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>11g\uc758 Table Compression with difference<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image8.png\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"image8\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image8_thumb.png?resize=244%2C5\" alt=\"image8\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>\u201e Compression \uc2dc\uae30<\/p>\n<p>\uc0c8\ub85c\uc6b4 data\ub97c Bulk insert\ub098 bulk load \ub610\ub294 \uadf8\ub0e5 insert, update \ud560 \ub54c compression\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>\u2192 conventional DML\uc5d0\ub3c4 \uc801\uc6a9 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Direct path SQL*Loader<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; CREATE TABLE AS SELECT (CTAS) statements<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Parallel INSERT (or serial INSERT with an APPEND hint) statements<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Single-row or array inserts<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Single-row or array updates<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\uae30\uc874\uc758 data\ub294 ALTER TABLE\uacfc MOVE statement\ub85c compress\ud560 \uc218 \uc788\ub2e4. \uc774 \uacfc\uc815\uc5d0\ub294 exclusive lock\uc774 \uc0ac\uc6a9\ub418\uba70 \uc5b4\ub5a0\ud55c update\ub098 load\ub97c \ubc29\uc9c0\ud55c\ub2e4.<\/p>\n<p>\uc774\uac83\uc774 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\ub294\ub2e4\uba74 redefinition utility (DBMS_REDEFINITION PL\/SQL package)\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\u201e Note<\/p>\n<p>Compression\uacfc \uad00\ub828\ub41c overhead\ub294 bulk loading \uc911\uc5d0 \ucd5c\ub300\uac00 \ub41c\ub2e4. \ub610\ud55c, Compress\ub41c table\uc5d0 \ubaa8\ub4e0 DML\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>Uncompressed table\uacfc \ube44\uad50\ud574\uc11c\ub294 Update\uc744 \uc81c\uc678\ud55c \ub2e4\ub978 DML\uc5d0\uc11c\ub294 \ucc98\ub9ac\uc18d\ub3c4\uc0c1\uc758 \ucc28\uc774\uac00 \uac70\uc758 \uc5c6\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>* OLTP\uc640 DW \ud658\uacbd\uc5d0 \ub458 \ub2e4 \uc801\uc6a9 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<p>\u2192 \uc0c8\ub85c\uc6b4 data\ub97c write\ud560 \ub54c\ub9c8\ub2e4 block\uc744 compress\ud558\ub294 \ubc29\uc2dd\uc774 \uc544\ub2c8\ub77c \ub0b4\ubd80\uc801\uc778 threshold\ub97c \ub118\uc73c\uba74 batch mode\ub85c \ud55c\ubc88\uc5d0 compress\ud558\uae30 \ub54c\ubb38\uc5d0 OLTP\uc5d0 \uc801\uc6a9 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>* Oracle Advanced Compression Option\uc5d0 \ud3ec\ud568. (for OLTP)<\/p>\n<p>\u2192 11g Enterprise Edition\uc5d0\uc11c\ub294 10g \uae30\uc220\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. (for DW)<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Test for Table Compression<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image9.png\"><img loading=\"lazy\" style=\"margin: 0px; display: inline; background-image: none;\" title=\"image9\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/image9_thumb.png?resize=244%2C5\" alt=\"image9\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Requirements for Comparing Storage<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Granting Privileges to the SH User<\/p>\n<pre class=\"lang:plsql decode:true\">alter user sh identified by sh account unlock;\r\n\r\ngrant create tablespace to sh;\r\n\r\ngrant drop tablespace to sh;<\/pre>\n<p>\ud14c\uc2a4\ud2b8\ub97c \uc704\ud574\uc11c \uae30\ubcf8\uc801\uc73c\ub85c sh \uacc4\uc815\uacfc \ubcc4\ub3c4\uc758 tablespace \ub97c \ub9cc\ub4e4\uc5b4\uc11c \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub294 \ucc28\ud6c4 Storage \uc555\ucd95\ub960\uacfc DML \uc2dc\uac04\uc744 \ube44\uad50\ud558\ub294\ub370 \uc77c\uad00\ub41c \ud658\uacbd\uc5d0\uc11c \ud14c\uc2a4\ud2b8 \ud560 \uc218 \uc788\ub3c4\ub85d \uc81c\uacf5 \ub429\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Compressed table\uc640 uncompressed table \uc0dd\uc131<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/imagef.png\"><img loading=\"lazy\" style=\"margin: 0px; display: inline; background-image: none;\" title=\"imagef\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/imagef_thumb.png?resize=244%2C5\" alt=\"imagef\" width=\"244\" height=\"5\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>\ud14c\uc774\ube14\uc740 3\uac00\uc9c0\ub85c\ub098\ub204\uc5b4\uc11c \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>. nocompress : \uc555\ucd95\ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14<\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>. sales_compress_oltp : \ub808\ucf54\ub4dc \uc5c6\ub294 \uc555\ucd95 \ud14c\uc774\ube14(single-row inserts)<\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>. sales_compress_direct : \ub808\ucf54\ub4dc \ud3ec\ud568 \uc555\ucd95 \ud14c\uc774\ube14(bulk load)<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true\">connect sh\/sh\r\ndrop table sales_nocompress purge\r\n\/\r\ndrop table sales_compress_direct purge\r\n\/\r\ndrop table sales_compress_oltp purge\r\n\/\r\nset echo on\r\nset timing on\r\ncreate table sales_nocompress\r\nas select * from sales\r\n\/\r\ncreate table sales_compress_direct compress\r\nas select * from sales\r\n\/\r\ncreate table sales_compress_oltp compress &lt;-(for all operations)\ub85c \ud574\uc57c \ud558\uc9c0\ub9cc Beta version\uc778 \uad00\uacc4\ub85c \ubd88\uac00.\r\nas select * from sales\r\nwhere 1=0\r\n\/<\/pre>\n<p>&nbsp;<\/p>\n<p>. sales_compress_oltp : \ub808\ucf54\ub4dc \uc5c6\ub294 \uc555\ucd95 \ud14c\uc774\ube14\uc744 \uc0dd\uc131 \ud6c4 \ucd94\uac00\ub85c insert \ub97c \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true\">Select count(*) from sales_compress_oltp\r\n\/\r\n0 rows selected.<\/pre>\n<pre class=\"lang:plsql decode:true\">SQL&gt; @oltp_insert.sql\r\nSQL&gt; set timing on\r\nSQL&gt; declare\r\n2\r\n3 commit_after integer := 0 ;\r\n4 loop_variable integer ;\r\n5\r\n6 cursor c_sales is\r\n7 select prod_id\r\n8 , cust_id\r\n9 , time_id\r\n10 , channel_id\r\n11 , promo_id\r\n12 , quantity_sold\r\n13 , amount_sold\r\n14 from sales ;\r\n15\r\n16 begin\r\n17\r\n18 for r_sales in c_sales\r\n19 loop\r\n20\r\n21 if commit_after = 0\r\n22 then\r\n23\r\n24 loop_variable := 0 ;\r\n25\r\n26 commit_after := round(dbms_random.value(1,1)) ;\r\n27\r\n28 end if ;\r\n29\r\n30 insert into sales_compress_oltp\r\n31 (prod_id, cust_id, time_id, channel_id, promo_id, quantity_sold, amount_sold)\r\n32 values\r\n33 ( r_sales.prod_id\r\n34 , r_sales.cust_id\r\n35 , r_sales.time_id\r\n36 , r_sales.channel_id\r\n37 , r_sales.promo_id\r\n38 , r_sales.quantity_sold\r\n39 , r_sales.amount_sold\r\n40 ) ;\r\n41\r\n42 if loop_variable = commit_after\r\n43 then\r\n44 commit ;\r\n45 commit_after := 0 ;\r\n46 end if ;\r\n47\r\n48 loop_variable := loop_variable + 1 ;\r\n49\r\n50 end loop ;\r\n51\r\n52 end ;\r\n53 \/\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:15:34.64\r\nSQL&gt; set timing off<\/pre>\n<p>\ub3d9\uc77c\ud55c \ub808\ucf54\ub4dc\uac00 \uc788\uc74c\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:plsql decode:true\">SQL&gt; select count(*) from SALES_NOCOMPRESS;\r\nCOUNT(*)\r\n----------\r\n918843\r\nSQL&gt; select count(*) from SALES_COMPRESS_OLTP;\r\nCOUNT(*)\r\n----------\r\n918843\r\nSQL&gt; select count(*) from SALES_COMPRESS_DIRECT;\r\nCOUNT(*)\r\n----------\r\n918843<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Test \uacb0\uacfc<\/strong><\/p>\n<p><strong>Storage Compression-rate Comparison<\/strong><\/p>\n<p>\ub3d9\uc77c\ud55c \ub808\ucf54\ub4dc\ub97c \uac16\uace0 \uc788\ub294 3\uac1c\uc758 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 \uac01\uac01\uc758 Segment \ub97c \ucc28\uc9c0\ud558\ub294 \uacf5\uac04\uc744 \ube44\uad50\ud574 \ubd05\ub2c8\ub2e4.<\/p>\n<p>\uc5ec\uae30\uc11c <strong><span style=\"color: #ff0000;\">sales_compress_direct \ud14c\uc774\ube14\uc774 13M \ub85c \uac00\uc7a5 \ub9ce\uc774 \uc555\ucd95<\/span><\/strong>\ub41c \uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true\">SQL&gt; select segment_name, sum(bytes)\/1024\/1024 mb\r\n2 from dba_segments\r\n3 where owner = user\r\n4 and segment_name in ('SALES_NOCOMPRESS','SALES_COMPRESS_DIRECT','SALES_COMPRESS_OLTP')\r\n5 group by segment_name\r\n6 order by segment_name\r\n7 \/<\/pre>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">Oracle 10g \uacb0\uacfc<\/span><\/strong><\/p>\n<pre class=\"lang:plsql decode:true\">SEGMENT_NAME MB\r\n--------------------------------------------------------------------------------- ----------\r\nSALES_NOCOMPRESS 36\r\nSALES_COMPRESS_OLTP 32\r\nSALES_COMPRESS_DIRECT 13\r\n3 rows selected.<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>Oracle 11g \uacb0\uacfc<\/strong><\/span><\/p>\n<pre class=\"lang:plsql decode:true\">SEGMENT_NAME MB\r\n--------------------------------------------------------------------------------- ----------\r\nSALES_NOCOMPRESS 36\r\nSALES_COMPRESS_OLTP 17\r\nSALES_COMPRESS_DIRECT 13\r\n3 rows selected.<\/pre>\n<p>&nbsp;<\/p>\n<p>10g\uc5d0\uc11c\ub294 OLTP\ub85c insert\uc791\uc5c5\uc744 \uc218\ud589\ud55c table\uc740 data\uac00 \uc555\ucd95\uc774 \uc548\ub41c \uac83\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc 11g\uc5d0\uc11c OLTP\ub97c \ub300\uc0c1\uc73c\ub85c \ub9cc\ub4e0 \uc0c8\ub85c\uc6b4 feature, \u201ccompress for all operations\u201d\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\ub85c \uc555\ucd95\ub960\uc774 \ub354 \uc88b\uc544\uc9c4 \uac83\uc73c\ub85c \ubcf4\uc544 Enterprise Edition\uc5d0\uc11c \uae30\ubcf8\uc801\uc73c\ub85c \uc81c\uacf5\ud558\ub294 compression\uae30\ub2a5\uc774 \ud5a5\uc0c1\ub41c \uac83\uc73c\ub85c \ubcf4\uc5ec\uc9c4\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"font-size: 20px;\">DML Comparison<\/span><\/strong><\/p>\n<p>\uc555\ucd95\ub41c 3\uac1c\uc758 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c \ub3d9\uc77c\ud55c delete \uc791\uc5c5\uc744 \uc9c4\ud589 \ud558\uace0\uc790 \ud569\ub2c8\ub2e4.<br \/>\n\uac01\uac01\uc758 \uc2dc\uac04\uc744 \ube44\uad50\ud574\uc11c \uc555\ucd95\ub960\uc5d0 \ub530\ub77c DML \uc2dc\uac04\uc5d0 \uc5b4\ub5a0\ud55c , \uadf8\ub9ac\uace0 \uc5bc\ub9c8\ub098 \ub9ce\uc740 \uc601\ud5a5\uc774 \uc788\ub294\uc9c0 \ud655\uc778 \ud558\uace0\uc790\ud569\ub2c8\ub2e4.<\/p>\n<p><span style=\"color: #ff0000;\">. nocompress : \uc555\ucd95\ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14<\/span><br \/>\n<span style=\"color: #ff0000;\">. sales_compress_oltp : \ub808\ucf54\ub4dc \uc5c6\ub294 \uc555\ucd95 \ud14c\uc774\ube14<\/span><br \/>\n<span style=\"color: #ff0000;\">. sales_compress_direct : \ub808\ucf54\ub4dc \ud3ec\ud568 \uc555\ucd95 \ud14c\uc774\ube14<\/span><\/p>\n<p>\uc555\ucd95\ub960\uc740 \ub808\ucf54\ub4dc\uc640 \ud14c\uc774\ube14 \ubaa8\ub450 \uc555\ucd95\ud55c sales_compress_direct \uac00 \uac00\uc7a5 \ub192\ub2e4.<\/p>\n<p>SALES_COMPRESS_OLTP \ub294 \uc555\ucd95 \ud14c\uc774\ube14 \uc0dd\uc131 \ud6c4 insert \ud55c \uacb0\uacfc\ub85c \uc804\ubd80 \uc555\ucd95\ud55c \ud14c\uc774\ube14 \ubcf4\ub2e4\ub294 \ub2e4\uc18c \ub192\uc9c0\ub9cc \uc555\ucd95 \ud6a8\uacfc\ub294 \ud655\uc5f0\ud788 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n<pre class=\"lang:plsql decode:true\">SQL&gt; select table_name, compression from user_tables where table_name like '%COMPRESS%';\r\nTABLE_NAME COMPRESS\r\n------------------------------ --------\r\nSALES_NOCOMPRESS DISABLED\r\nSALES_COMPRESS_DIRECT ENABLED\r\nSALES_COMPRESS_OLTP ENABLED\r\n3 rows selected.<\/pre>\n<p>&nbsp;<\/p>\n<p>. nocompress : \uc555\ucd95\ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14 \uc774 \uc0ad\uc81c\uc791\uc5c5\uc2dc \uac00\uc7a5 \ube60\ub974\uc9c0\ub9cc \ud070 \ucc28\uc774\ub97c \ubcf4\uc774\uc9c4 \uc54a\ub294\ub2e4.<\/p>\n<pre class=\"lang:plsql decode:true\">SQL&gt; set timing on\r\nSQL&gt; delete from sales_nocompress;\r\n918843 rows deleted.\r\nElapsed: 00:00:34.59\r\nSQL&gt; set timing off\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>. sales_compress_oltp : \ub808\ucf54\ub4dc \uc5c6\ub294 \uc555\ucd95 \ud14c\uc774\ube14 \uc0dd\uc131 \ud6c4 \ucd94\uac00 insert \ud55c \ud14c\uc774\ube14 \uc740 DML \uc5d0\uc11c \uc804\ubd80 \uc555\ucd95\ud55c \ud14c\uc774\ube14 \ubcf4\ub2e4\ub294 \ube60\ub974\ub2e4.<\/p>\n<pre class=\"lang:plsql decode:true\">SQL&gt; set timing on\r\nSQL&gt; delete from SALES_COMPRESS_OLTP;\r\n918843 rows deleted.\r\nElapsed: 00:00:35.73\r\nSQL&gt; set timing off\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>. sales_compress_direct : \ub808\ucf54\ub4dc \ud3ec\ud568\ud55c \uc804\uccb4 \uc555\ucd95 \ud14c\uc774\ube14 \uc774 \uc555\ucd95 \uc548\ud55c \ud14c\uc774\ube14 \ubcf4\ub2e4 \uc870\uae08 \ub290\ub9b0 \uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\ub2e4.<\/p>\n<pre class=\"lang:plsql decode:true\">SQL&gt; set timing on\r\nSQL&gt; delete from SALES_COMPRESS_DIRECT;\r\n918843 rows deleted.\r\nElapsed: 00:00:38.82\r\nSQL&gt; set timing off\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p style=\"line-height: 12.65pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 22pt; mso-line-height-rule: yes;\"><span style=\"color: #ff0000;\"><strong><span style=\"font-size: 20px;\">\ube44\uad50\u00a0\uacb0\uacfc<\/span><\/strong><\/span><\/p>\n<p style=\"line-height: 10pt; margin-top: 0pt; margin-bottom: 0pt; mso-line-height-rule: yes;\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/p>\n<p style=\"line-height: 15.75pt; margin-top: 0pt; margin-bottom: 0pt; mso-line-height-rule: yes;\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/p>\n<table style=\"line-height: normal; margin-left: 0.18mm; border-collapse: collapse;\" width=\"680\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"200\" \/>\n<col width=\"180\" \/>\n<col width=\"148\" \/>\n<col width=\"152\" \/><\/colgroup>\n<tbody style=\"vertical-align: middle;\">\n<tr style=\"height: 22.4pt; vertical-align: middle;\">\n<td style=\"background: gray; border-width: 1pt; border-style: solid; border-color: gray silver gray gray; padding: 1px; vertical-align: middle; mso-shading: gray; mso-border-left-alt: solid gray 1pt; mso-border-right-alt: solid silver 1pt; mso-border-top-alt: solid gray 1pt; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"200\" height=\"29\">\n<p style=\"line-height: 11.5pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 55pt; mso-line-height-rule: yes;\"><span style=\"font-size: 10pt;\">\ud14c\uc774\ube14\uba85<\/span><\/p>\n<\/td>\n<td style=\"border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: gray silver currentcolor currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid silver 1pt; mso-border-top-alt: solid gray 1pt; mso-border-bottom-alt: none;\" valign=\"bottom\" width=\"180\" height=\"29\">\n<p style=\"line-height: 12.2pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 31pt; mso-line-height-rule: yes;\"><span style=\"font-size: 10pt;\">Compress <\/span><span style=\"font-size: 10pt;\">\ubc29\uc2dd<\/span><\/p>\n<\/td>\n<td style=\"border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: gray silver currentcolor currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid silver 1pt; mso-border-top-alt: solid gray 1pt; mso-border-bottom-alt: none;\" valign=\"bottom\" width=\"148\" height=\"29\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"mso-font-width: 99%;\"><span style=\"font-size: 10pt;\">Storage<br \/>\n(MB)<\/span><\/span><\/p>\n<\/td>\n<td style=\"border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: gray gray currentcolor currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: solid gray 1pt; mso-border-bottom-alt: none;\" valign=\"bottom\" width=\"152\" height=\"29\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"font-size: 10pt;\">DML (s)<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 12.5pt; vertical-align: middle;\">\n<td style=\"padding: 1px; border: 1pt solid gray; vertical-align: middle; mso-border-alt: solid gray 1pt;\" valign=\"bottom\" width=\"200\" height=\"16\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 6pt;\"><span style=\"font-size: 10pt;\">nocompress<\/span><\/p>\n<\/td>\n<td style=\"border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: gray gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: solid gray 1pt; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"180\" height=\"16\">\n<p style=\"line-height: 11pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 5pt; mso-line-height-rule: yes;\"><span style=\"font-size: 10pt;\">\uc555\ucd95\ub418\uc9c0<\/span><span style=\"font-size: 10pt;\">\u00a0\uc54a\uc740\u00a0<\/span><span style=\"font-size: 10pt;\">\ud14c\uc774\ube14<\/span><\/p>\n<\/td>\n<td style=\"border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: gray gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: solid gray 1pt; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"148\" height=\"16\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"mso-font-width: 98%;\"><span style=\"font-size: 10pt;\">36<\/span><\/span><\/p>\n<\/td>\n<td style=\"border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: gray gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: solid gray 1pt; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"152\" height=\"16\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"mso-font-width: 99%;\"><span style=\"font-size: 8pt;\">34.59<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 16.95pt; vertical-align: middle;\">\n<td style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor gray gray; padding: 1px; vertical-align: middle; mso-border-left-alt: solid gray 1pt; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"200\" height=\"22\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 6pt;\"><span style=\"font-size: 10pt;\">sales_compress_oltp<\/span><\/p>\n<\/td>\n<td style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"180\" height=\"22\">\n<p style=\"line-height: 13.7pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 5pt; mso-line-height-rule: yes;\"><span style=\"font-size: 10pt;\">\uc77c\ubc18<\/span><span style=\"font-size: 10pt;\">load <\/span><span style=\"font-size: 10pt;\">\uc555\ucd95\u00a0<\/span><span style=\"font-size: 10pt;\">\ud14c\uc774\ube14<\/span><\/p>\n<\/td>\n<td style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"148\" height=\"22\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"mso-font-width: 98%;\"><span style=\"font-size: 10pt;\">17<\/span><\/span><\/p>\n<\/td>\n<td style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"152\" height=\"22\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"mso-font-width: 99%;\"><span style=\"font-size: 8pt;\">35.73<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 16.95pt; vertical-align: middle;\">\n<td style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor gray gray; padding: 1px; vertical-align: middle; mso-border-left-alt: solid gray 1pt; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"200\" height=\"22\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 6pt;\"><span style=\"font-size: 10pt;\">sales_compress_direct<\/span><\/p>\n<\/td>\n<td style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"180\" height=\"22\">\n<p style=\"line-height: 13.7pt; margin-top: 0pt; margin-bottom: 0pt; margin-left: 5pt; mso-line-height-rule: yes;\"><span style=\"font-size: 10pt;\">Direct_load<\/span><span style=\"font-size: 10pt;\">\uc555\ucd95\u00a0<\/span><span style=\"font-size: 10pt;\">\ud14c\uc774\ube14<\/span><\/p>\n<\/td>\n<td style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"148\" height=\"22\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"mso-font-width: 98%;\"><span style=\"font-size: 10pt;\">13<\/span><\/span><\/p>\n<\/td>\n<td style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor gray gray currentcolor; padding: 1px; vertical-align: middle; mso-border-left-alt: none; mso-border-right-alt: solid gray 1pt; mso-border-top-alt: none; mso-border-bottom-alt: solid gray 1pt;\" valign=\"bottom\" width=\"152\" height=\"22\">\n<p style=\"line-height: 12pt; margin-top: 0pt; margin-bottom: 0pt;\" align=\"center\"><span style=\"mso-font-width: 99%;\"><span style=\"font-size: 8pt;\">38.82<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Oracle9i \uc5d0\uc11c \ubc8c\ud06c \ub85c\ub529\uc744 \uc704\ud55c \ud14c\uc774\ube14 \uc555\ucd95\uc744 \ub3c4\uc785\ud588\uc744 \ub54c\ubd80\ud130 Oracle\uc740 \uc774\ubbf8 \uc5c5\uacc4\uc5d0\uc11c \uc120\uad6c\uc801\u00a0<\/strong><strong>\uc5ed\ud560\uc744 \uc218\ud589\ud574 \uc654\ub2e4. <\/strong><\/p>\n<p><strong>\uace0\uac1d\uc740 \uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uc5ec <span style=\"color: #ff0000;\">Direct Loading\uc774\ub098 CTAS\ub4f1\uacfc \uac19\uc740 \uc791\uc5c5\uc744 \ud1b5\ud574\u00a0<\/span><\/strong><strong><span style=\"color: #ff0000;\">\ubc8c\ud06c \ub85c\ub529\uc744 \uc218\ud589<\/span>\ud558\uba74\uc11c \ub370\uc774\ud130\ub97c \uc555\ucd95\ud560 \uc218 \uc788\uc5c8\uc9c0\ub9cc, <\/strong><\/p>\n<p><span style=\"color: #ff0000;\"><strong>\ubc8c\ud06c\ub85c \ub85c\ub529\ud558\uba74\uc11c \uc555\ucd95\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud574\u00a0<\/strong><\/span><strong><span style=\"color: #ff0000;\">DML \uc791\uc5c5\uc774 \ubc1c\uc0dd\ud558\uba74 \uc774\ud6c4\ubd80\ud130\ub294 \uc555\ucd95\uc774 \ud480\ub9b0 \uc0c1\ud0dc\ub85c \uad00\ub9ac<\/span>\ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 INSERT, UPDATE,\u00a0<\/strong><strong>DELETE\uc640 \uac19\uc740 \uc77c\ubc18\uc801\uc778 \ub370\uc774\ud130 \uc791\uc5c5\uc5d0\uc11c\ub294 \uc555\ucd95\uc744 \ud65c\uc6a9\ud560 \uc218 \uc5c6\uc5c8\ub2e4.<\/strong><\/p>\n<p><strong>Oracle11g \uc5d0 \uc640\uc11c\ub294 \uc77c\ubc18\uc801\uc778 DML \uc791\uc5c5\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc555\ucd95\uc774 \uac00\ub2a5\ud574\uc84c\uae30 \ub54c\ubb38\uc5d0, DW \uc2dc\uc2a4\ud15c\uc5d0\uc11c\u00a0<\/strong><strong>\ucf54\ub4dc\uc131\uc774\ub098 \ubd84\uc11d Dimension \ud14c\uc774\ube14\uc5d0\ub9cc \uc801\uc6a9\ud558\ub358 \uac83\uc5d0\uc11c \ubc97\uc5b4\ub098, OLTP \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub370\uc774\ud130\uc5d0 \ub300\ud55c\u00a0<\/strong><strong>\ubcc0\uacbd\uc774 \ubc1c\uc0dd\ud558\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc555\ucd95\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ub418\uc5c8\ub2e4.<\/strong><\/p>\n<p><strong>Oracle\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc555\ucd95 \uba54\ucee4\ub2c8\uc998\uc740 \ube14\ub85d \ub2e8\uc704\ub85c \uc555\ucd95\ub418\uba70, \ubc18\ubcf5\ub418\ub294 \ub370\uc774\ud130\ub97c \ube14\ub85d \ud5e4\ub354\uc5d0 \ud55c\u00a0<\/strong><strong>\ubc88\ub9cc \uc800\uc7a5\ud558\ub294 \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4. \uc774\uac83\uc740 \uc555\ucd95\uc744 \ud480\uae30 \uc704\ud574 \ud574\uc57c\ud560 \ubd88\ud544\uc694\ud55c \uc5f0\uc0b0 \uc791\uc5c5\uc744\u00a0<\/strong><strong>\uc5c6\uc570\uc73c\ub85c\uc368, \uc555\ucd95 \ud574\uc81c\uc758 \uc624\ubc84\ud5e4\ub4dc\ub97c \ucd5c\uc18c\ud654 \uc2dc\ud0a4\ub294 \uc5ed\ud560\uc744 \ud558\uace0 \uc788\ub2e4.<\/strong><\/p>\n<p><strong>\uc774\ub85c\uc368, \ubcc0\uacbd\uc774 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\uac70\ub098 \ubbf8\ubbf8\ud55c \ucf54\ub4dc\uc131 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c\ub294 OLTP \uc2dc\uc2a4\ud15c\uc774\ub77c\uace0 \ud558\ub354\ub77c\ub3c4\u00a0<\/strong><strong>Oracle11g\uc758 Advanced Compression Option\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc555\ucd95\ud574 \ub193\ub294\ub2e4\uba74, \uace0\uac00\uc758 \uace0\uc131\ub2a5\u00a0<\/strong><strong>\uc2a4\ud1a0\ub9ac\uc9c0\ub97c \ud55c\uce35 \ub354 \ud6a8\uc728\uc801\uc73c\ub85c \ud65c\uc6a9\ud560 \uc218 \uc788\uc744 \uac83\uc774\ub2e4. <\/strong><\/p>\n<p><strong>\ub610\ud55c, <span style=\"color: #ff0000;\">Information Lifecycle\u00a0<\/span><\/strong><strong><span style=\"color: #ff0000;\">Management(ILM)\uc758 \uad00\uc810<\/span>\uc5d0\uc11c \ud604\uc7ac online\uc73c\ub85c \uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ub294 \uc544\ub2c8\uc9c0\ub9cc \uc815\ud574\uc9c4 \ubcf4\uad00 \uae30\uac04 \ub3d9\uc548\u00a0<\/strong><strong>\uc800\uc7a5\ub418\uc5b4 \uc788\uc5b4\uc57c \ud560 \ub370\uc774\ud130\uc5d0 \ub300\ud574\uc11c\ub3c4 Oracle11g \uc758 Advanced Compression Option\uc744 \uc774\uc6a9\ud558\uc5ec\u00a0<\/strong><strong>\uc555\ucd95\ud558\uba74 \ubc29\ub300\ud55c \uc800\uc7a5 \ub370\uc774\ud130\ub97c \ub354 \uc801\uc740 \ube44\uc6a9\uc73c\ub85c \ubcf4\uad00 \ubc0f \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/strong><\/p>\n<p><strong> \ucd95\uc801\ub418\uc5b4 \uc628 \uacfc\uac70\uc758 \uc774\ub825\u00a0<\/strong><strong>\ub370\uc774\ud130\ub97c \uad00\ub9ac\ud574\uc57c \ud560 \uae30\uc5c5\uc758 \ub2f9\uba74\uacfc\uc81c\ub97c \ud574\uacb0\ud560 \ud6a8\uc728\uc801\uc778 \uc194\ub8e8\uc158\uc778 \uac83\uc774\ub2e4.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc9c0\ub09c 10 \ub144 \ub3d9\uc548 \uae30\uc5c5\uc5d0\uc11c \ub2e4\ub8e8\uc5b4\uc9c0\ub294 \uace0\uac1d\ub370\uc774\ud130\uc640 \uc601\uc5c5\ud65c\ub3d9 \ubc0f \uac70\ub798\ub85c\ubd80\ud130 \ubc1c\uc0dd\ud55c \ub370\uc774\ud130\ub294 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \uc99d\uac00\ud574\uc654\ub2e4. \ucd5c\uadfc\uc5d0\ub294 \uae30\uc5c5 \ub370\uc774\ud130\uc758 \uc601\uc5ed\uc774 \uae30\uc874\uc758 \uc815\ud615 \ub370\uc774\ud130\uc5d0\uc11c \ube44\uc815\ud615 \ub370\uc774\ud130\ub85c\uae4c\uc9c0 \ud655\ub300\ub418\uace0 \uc788\uc5b4\uc11c \uadf8 \uc99d\uac00\uc758 \uc18d\ub3c4\ub294 \ub354\uc6b1 \ube68\ub77c\uc9c0\uace0 \uc788\ub2e4. Winter Corp\uc5d0\uc11c \ubc1c\ud45c\ud558\ub294 \uae30\uc5c5 \uc804\uc0b0 \uc2dc\uc2a4\ud15c\uc758 \ub370\uc774\ud130 \uc0ac\uc774\uc988 \ud1b5\uacc4\uc5d0 \ub530\ub974\uba74, 2003\ub144\uc5d0\ub294 30TB\uc758 FT(France Telecom)\uc774 \uac00\uc7a5 \ud070 \uaddc\ubaa8\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc600\uace0, 2005\ub144\uc5d0\ub294 Yahoo\uc758 100TB, 2006\ub144 \ub9d0\uc5d0\ub294 \ud638\uc8fc\uc5d0\uc11c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3434,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[983,987,988,990,989,985,984,986],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Copias-de-seguridad.png?fit=690%2C335","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3431"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3431"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3431\/revisions"}],"predecessor-version":[{"id":3436,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3431\/revisions\/3436"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3434"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3431"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}