1.Dual Format<\/a><\/p>\n 2.In-Memory Column Store<\/a><\/p>\n In-Memory \uc124\uc815 \ubc29\ubc95<\/a><\/p>\n \ud30c\ub77c\ubbf8\ud130 \uc124\uc815<\/a><\/p>\n INMEMORY_SIZE<\/a><\/p>\n In-Memory \uc635\uc158\uc758 Priority \uc18d\uc131<\/a><\/p>\n In-Memory \uc635\uc158\uc758 Compression \uc18d\uc131<\/a><\/p>\n Test<\/a><\/p>\n 1. In-Memory \uc124\uc815\uc744 \uc704\ud574 inmemory_size \uac12\u00a0\uc124\uc815<\/a> \ucc38\uace0)<\/a><\/p>\n 6. In-Memory \uc635\uc158\uc758 Compression \uc18d\uc131\u00a0\uc124\uc815<\/a><\/p>\n <\/p>\n <\/p>\n Oracle Database In-Memory\ub294 \uc804\ud1b5\uc801\uc778 Row Format \ubc29\uc2dd\uc5d0 Column Format \ubc29\uc2dd\uc744 \ucd94\uac00\ub85c \uc9c0\uc6d0\ud574 OLTP, DW \uc5c5\ubb34\uac00 \ud63c\uc7ac\ub41c \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac\uc640, \ub370\uc774\ud130 \ubd84\uc11d \ub4f1\uc758 \ubaa8\ub4e0 \uc5c5\ubb34 \ud504\ub85c\uc138\uc2a4\ub97c \uc9c0\uc6d0\ud55c\ub2e4. Oracle\uc740\u00a0\ub450\uac00\uc9c0 Format\u00a0\uc0ac\uc6a9\uc744 Dual Format \uc9c0\uc6d0\uc774\ub77c\uace0 \uc774\uc57c\uae30 \ud55c\ub2e4. In-Memory \uae30\ub2a5\uc740 \uc624\ub77c\ud074 12.1.0.2 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n \uae30\uc874 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ubcc0\uacbd \uc5c6\uc774 \ubd84\uc11d \ucffc\ub9ac\uc640 OLTP \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac \uc18d\ub3c4\ub97c \ubaa8\ub450 \ub192\uc77c \uc218 \uc788\ub2e4\uace0 \ud55c\ub2e4. \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \uc790\ub3d9\uc73c\ub85c \ubd84\uc11d \ucffc\ub9ac\uc758 \uacbd\uc6b0 Column Format\uc73c\ub85c OLTP\uc758 \uacbd\uc6b0 Row Format\uc73c\ub85c \uc0ac\uc6a9\ud558\uac8c \ud558\uc5ec \uc5c5\ubb34 \ud504\ub85c\uc138\uc2a4\ub97c \ube60\ub974\uac8c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud574 \uc900\ub2e4.<\/p>\n \uc624\ub77c\ud074\uc740 Dual Format \uc544\ud0a4\ud14d\ucc98\ub97c \uc0ac\uc6a9\ud55c\ub2e4\uace0 \ud574\uc11c \ud544\uc694\ub85c \ud558\ub294 \uba54\ubaa8\ub9ac\uac00 \ub450\ubc30\ub85c \ub298\uc5b4\ub09c \uac83\uc774 \uc544\ub2c8\ub77c \uc57d 20% \uc815\ub3c4\uc758 \ucd94\uac00 \uc0ac\uc6a9\ud560 \uac83\uc774\ub77c\uace0 \uc608\uc0c1\ud558\uace0 \uc788\ub2e4.<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n Priority \uac12\uc5d0 \ub530\ub77c\uc11c IM Column Store\uc5d0 Load \ub418\ub294 \uc2dc\uc810\uc774 \uacb0\uc815\ub41c\ub2e4.<\/p>\n <\/p>\n <\/p>\n <\/p>\n \ucffc\ub9ac\uc758 \uc131\ub2a5\uacfc \uacf5\uac04 \uc808\uc57d\uc744 \uc704\ud574 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uc18d\uc131\uc784<\/p>\n \uc555\ucd95 \ube44\uc728\uc740 \ucd5c\uc18c 2\ubc30\uc5d0\uc11c \ucd5c\ub300 20\ubc30\uae4c\uc9c0 \ub420 \uc218 \uc788\ub2e4\uace0 \ud568<\/p>\n <\/p>\n <\/p>\n <\/p>\n
\n2. 100M \uc774\ud558 \uc124\uc815 \uc81c\uc57d<\/a>
\n3. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ub808\ubca8\uc5d0\uc11c In-Memory \uc124\uc815<\/a>
\n4. \ud14c\uc774\ube14 \ub808\ubca8\uc5d0\uc11c In-Memory \uc635\uc158 \uc124\uc815<\/a>
\n5. Column \ub808\ubca8\uc5d0\uc11c In-Memory \uc635\uc158 \uc124\uc815<\/a><\/p>\n<\/a>Oracle Database In-Memory Option\uc774\ub780?<\/h2>\n
\u00a0 \u00a0<\/a>1. Dual Format<\/h3>\n
<\/h4>\n
![\"in_memory_01.png\"](\"https:\/\/i0.wp.com\/www.koreaoug.org\/files\/attach\/images\/256\/935\/0a4f350ae820b5bdf17bfab7806d8452.png?w=640\")
<\/h4>\n\u00a0 \u00a0 \u00a0 A.\u00a0Row Format<\/h4>\n
\n
\u00a0 \u00a0 \u00a0 B.\u00a0Column Format<\/h4>\n
\n
\u00a0 \u00a0<\/a>2. In-Memory Column Store(IM Column Store)<\/h3>\n
\n
<\/a>In-Memory \uc124\uc815 \ubc29\ubc95<\/h2>\n
<\/a>\ud30c\ub77c\ubbf8\ud130 \uc124\uc815<\/h3>\n
<\/a>INMEMORY_SIZE<\/h4>\n
\n\n
\n \nProperty<\/th>\n Description<\/th>\n<\/tr>\n<\/thead>\n \n Parameter type<\/td>\n Big integer<\/td>\n<\/tr>\n \n Syntax<\/td>\n INMEMORY_SIZE = integer[K|M|G]<\/td>\n<\/tr>\n \n Default value<\/td>\n 0<\/td>\n<\/tr>\n \n Modifiable<\/td>\n ALTER SYSTEM<\/td>\n<\/tr>\n \n Range of values<\/td>\n 0 to the amount of memory left in the SGA after other allocations<\/td>\n<\/tr>\n \n Basic<\/td>\n No<\/td>\n<\/tr>\n \n Oracle RAC<\/td>\n All instances should use the same value.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \n
<\/a>In-Memory \uc635\uc158\uc758 Priority \uc18d\uc131<\/h3>\n
\n\n
\n \nPriority<\/th>\n Description<\/th>\n<\/tr>\n<\/thead>\n \n CRITICAL<\/th>\n DB\uac00 Open \ub418\uc790 \ub9c8\uc790 IM Column Store\uc5d0\u00a0Load \ub428<\/td>\n<\/tr>\n \n HIGH<\/th>\n CRITICAL \uc635\uc158\uc758 Object\uac00 Load \ub418\uace0 \ub09c \ud6c4 \ub0a8\uc544 \uc788\ub294 \uacf5\uac04\uc5d0 Load \ub428<\/td>\n<\/tr>\n \n MEDIUM<\/th>\n CRITICAL, HIGH \uc635\uc158\uc758 Object\uac00 Load \ub418\uace0 \ub09c \ud6c4 \ub0a8\uc544 \uc788\ub294 \uacf5\uac04\uc5d0 Load \ub428<\/td>\n<\/tr>\n \n LOW<\/th>\n CRITICAL, HIGH, MEDIUM \uc635\uc158\uc758 Object\uac00 Load \ub418\uace0 \ub09c \ud6c4 \ub0a8\uc544 \uc788\ub294 \uacf5\uac04\uc5d0 Load \ub428<\/td>\n<\/tr>\n \n NONE<\/th>\n IM Column Store\uc5d0 \uacf5\uac04\uc774 \ub0a8\uc544 \uc788\ub294 \uacbd\uc6b0 Object\uac00 \ucd5c\ucd08 \uc2a4\uce94\ub41c \ud6c4 Load \ub428<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \uc81c\uc57d\uc0ac\ud56d(IM Column Store\uc5d0 Load \ub418\uc9c0 \ubabb\ud568)<\/h4>\n
\n
<\/a>In-Memory \uc635\uc158\uc758 Compression\u00a0\uc18d\uc131<\/h3>\n
\n\n
\n \nCompression Level<\/th>\n Description<\/th>\n<\/tr>\n<\/thead>\n \n NO MEMCOMPRESS<\/th>\n \uc555\ucd95\ud558\uc9c0 \uc54a\uc74c<\/td>\n<\/tr>\n \n MEMCOMPRESS FOR DML<\/th>\n DML \uc131\ub2a5\uc5d0 \ucd5c\uc801\ud654\ub97c \uc704\ud55c \ucd5c\uc18c \uc555\ucd95<\/td>\n<\/tr>\n \n MEMCOMPRESS FOR QUERY LOW<\/th>\n \uae30\ubcf8\uac12\uc774\uba70 \ucffc\ub9ac \uc131\ub2a5\uc5d0 \ucd5c\uc801\ud654\ub97c \uc704\ud55c \uc555\ucd95<\/td>\n<\/tr>\n \n MEMCOMPRESS FOR QUERY HIGH<\/th>\n \uacf5\uac04 \uc808\uc57d\uacfc \ucffc\ub9ac \uc131\ub2a5\uc5d0 \ucd5c\uc801\ud654\ub97c \uc704\ud55c \uc555\ucd95<\/td>\n<\/tr>\n \n MEMCOMPRESS FOR CAPACITY LOW<\/th>\n \uacf5\uac04 \uc808\uc57d\uacfc \uc131\ub2a5 \uc911 \uacf5\uac04 \uc808\uc57d\uc744 \ub2e4\uc18c \uc0c1\uc704\uc5d0 \ub454 \uc555\ucd95<\/td>\n<\/tr>\n \n MEMCOMPRESS FOR CAPACITY HIGH<\/th>\n \uacf5\uac04 \uc808\uc57d \ucd5c\uc801\ud654\ub97c \uc704\ud55c \uc555\ucd95<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/a>Test<\/h3>\n
<\/a>1. In-Memory \uc124\uc815\uc744 \uc704\ud574 inmemory_size \uac12\u00a0\uc124\uc815<\/h4>\n