{"id":4010,"date":"2018-07-01T20:22:19","date_gmt":"2018-07-01T11:22:19","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4010"},"modified":"2018-07-01T20:22:19","modified_gmt":"2018-07-01T11:22:19","slug":"in-memory-oracle-12c-%eb%8c%80%ec%9a%a9%eb%9f%89-%eb%b0%b0%ec%b9%98%ed%8e%b8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4010","title":{"rendered":"In-Memory Oracle 12c (\ub300\uc6a9\ub7c9 \ubc30\uce58\ud3b8)"},"content":{"rendered":"

In-Memory Column Store DML \ucc98\ub9ac<\/h2>\n

IM Column Store\uc5d0\uc11c\uc758 DML \ucc98\ub9ac\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

Data Loads \u2013 \uc2dc\ub098\ub9ac\uc624 1<\/h4>\n

\uccab\ubc88\uc9f8 \uc2dc\ub098\ub9ac\uc624\ub294 SALES1 \ud14c\uc774\ube14\uc744 \ub514\ud3f4\ud2b8 priority\ub85c \uc0dd\uc131\ud558\uace0 non-direct path data load \uc218\ud589\ud588\uc744 \ub54c\uc785\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
[oracle@New-Features-12c ~]$ sqlplus labuser\/labuser@pdb1<\/span>
\n<\/span><\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 28 11:36:05 2015
\n<\/span><\/p>\n

Copyright (c) 1982, 2014, Oracle. All rights reserved.
\n<\/span><\/p>\n

Last Successful login time: Fri Aug 28 2015 06:26:43 +00:00
\n<\/span><\/p>\n

Connected to:
\n<\/span><\/p>\n

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
\n<\/span><\/p>\n

With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
\n<\/span><\/p>\n

and Real Application Testing options
\n<\/span><\/p>\n

SQL> create table sales1 as select * from sales where 1=2;
\n<\/span><\/span><\/p>\n

Table created.
\n<\/span><\/p>\n

SQL> alter table sales1 inmemory;
\n<\/span><\/span><\/p>\n

Table altered.
\n<\/span><\/p>\n

SQL> insert into sales1 select * from sales where rownum <= 10000;
\n<\/span><\/span><\/p>\n

10000 rows created.
\n<\/span><\/p>\n

SQL> commit;
\n<\/span><\/span><\/p>\n

Commit complete.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Commit\uc744 \ud588\uc74c\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 v$im_segments\ub97c \ud1b5\ud574 \ud655\uc778\ud588\uc744 \ub54c SALES1 \ud14c\uc774\ube14\uc774 \uc544\uc9c1 population \ub418\uc9c0 \uc54a\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> col segment_name for a20<\/span>
\n<\/span><\/p>\n

SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated
\n<\/span><\/span><\/p>\n

from v$im_segments where segment_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

no rows selected<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

IM transactions<\/strong> : Transactions issued by the session to In-Memory tables (i.e. the number of times COMMITs have been issued)<\/p>\n

IM transactions rows journaled<\/strong> : Count of rows logged in the Transaction Journal by the session.<\/p>\n

IM populate segments requested<\/strong> : The number of times the session has requested for In-Memory population of a segment.<\/p>\n

\uc138\uc158 \ud1b5\uacc4\uc815\ubcf4\ub97c \ud1b5\ud574SALES1 \ud14c\uc774\ube14\uc5d0 \uc2e4\ud589\ub41c \ud2b8\ub79c\uc81d\uc158(IM transactions)\uc740 1\ud68c\uc774\uba70 Transaction Journal\uc5d0 \uae30\ub85d\ub41c \ub85c\uc6b0 \uc218(IM transactions rows journaled) \ub294 10000 \uc774\uc9c0\ub9cc \ud574\ub2f9 \uc138\uadf8\uba3c\ud2b8\uc5d0 \ub300\ud55c population \uc694\uccad(IM populate segments requested)\uc740 \uc544\uc9c1 \uc5c6\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> set lines 120<\/span>
\n<\/span><\/p>\n

SQL> col value for 999999999999999<\/span>
\n<\/span><\/p>\n

SQL> select display_name, value
\n<\/span><\/span><\/p>\n

from v$mystat m, v$statname n
\n<\/span><\/p>\n

where m.statistic# = n.statistic#
\n<\/span><\/p>\n

and n.display_name in (
\n<\/span><\/p>\n

‘IM populate segments requested’ ,
\n<\/span><\/p>\n

‘IM transactions’ ,
\n<\/span><\/p>\n

‘IM transactions rows journaled’);<\/span>
\n<\/span><\/p>\n

DISPLAY_NAME VALUE
\n<\/span><\/p>\n

—————————————————————- —————-
\n<\/span><\/p>\n

IM transactions 1
\n<\/span><\/p>\n

IM transactions rows journaled 10000
\n<\/span><\/p>\n

IM populate segments requested 0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

DBMS_INMEMORY.POPULATE \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud574\uc11c \uc218\ub3d9\uc73c\ub85c SALES1 \ud14c\uc774\ube14\uc744 populate \ud569\ub2c8\ub2e4. \ud504\ub85c\uc2dc\uc800 \uc2e4\ud589 \ud6c4 population \uc0c1\ud0dc\ub97c \ub515\uc154\ub108\ub9ac\ubdf0\uc5d0\uc11c \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> execute dbms_inmemory.populate(‘LABUSER’,’SALES1′,null);<\/span>
\n<\/span><\/p>\n

PL\/SQL procedure successfully completed.
\n<\/span><\/p>\n

SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated
\n<\/span><\/span><\/p>\n

from v$im_segments where segment_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 458752 1179648 0<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Population \uc0c1\uc138 \uc0c1\ud0dc\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. SALES1 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 7\uac1c \uc775\uc2a4\ud150\ud2b8\uac00 \uc0dd\uc131\ub418\uc5b4 \uc788\uace0 \uc5ec\uae30\uc5d0\ub294 56\uac1c \ube14\ub85d\uc774 \ud560\ub2f9\ub418\uc5b4 \uc788\uc73c\ub098 50\uac1c \ube14\ub85d\uc774 \uc0ac\uc6a9\uc911(DATABLOCKS)\uc784\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9 \uc911\uc778 50\uac1c \ube14\ub85d \ubaa8\ub450 IM Column Store\uc5d0 population \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4 (BLOCKSINMEM)<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> col object_name for a20<\/span>
\n<\/span><\/p>\n

SQL> select a.object_name, b.membytes, b.extents, b.blocks,
\n<\/span><\/span><\/p>\n

b.datablocks, b.blocksinmem, b.bytes
\n<\/span><\/p>\n

from v$im_segments_detail b, dba_objects a
\n<\/span><\/p>\n

where a.data_object_id = b.dataobj
\n<\/span><\/p>\n

and a.object_name = ‘SALES1’;
\n<\/span><\/p>\n

OBJECT_NAME MEMBYTES EXTENTS BLOCKS DATABLOCKS BLOCKSINMEM BYTES
\n<\/span><\/p>\n

——————– ———- ———- ———- ———- ———– ———-
\n<\/span><\/p>\n

SALES1 1179648 7 56 50 50 458752<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Data Loads \u2013 \uc2dc\ub098\ub9ac\uc624 2<\/h4>\n

\uc774\ubc88\uc5d0\ub294 Insert as Select \uad6c\ubb38\uc73c\ub85c SALES1 \ud14c\uc774\ube14\uc5d0 \ucd94\uac00 \ub370\uc774\ud130\ub97c \uc785\ub825\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

“IM transactions” \uc774 commit\uc73c\ub85c \uc778\ud574 \uae30\uc874 1\uc5d0\uc11c 2\ub85c \uc99d\uac00\ud558\uace0, “IM transactions rows journaled” \uac12\uc774 10000\uc5d0\uc11c 10100\uc73c\ub85c \ubcc0\uacbd\ub418\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> insert into sales1 select * from sales where rownum <= 100;<\/span>
\n<\/span><\/p>\n

100 rows created.
\n<\/span><\/p>\n

SQL> commit;<\/span>
\n<\/span><\/p>\n

Commit complete.
\n<\/span><\/p>\n

SQL> select display_name, value
\n<\/span><\/span><\/p>\n

from v$mystat m, v$statname n
\n<\/span><\/p>\n

where m.statistic# = n.statistic#
\n<\/span><\/p>\n

and n.display_name in (
\n<\/span><\/p>\n

‘IM populate segments requested’ ,
\n<\/span><\/p>\n

‘IM transactions’ ,
\n<\/span><\/p>\n

‘IM transactions rows journaled’);<\/span>
\n<\/span><\/p>\n

DISPLAY_NAME VALUE
\n<\/span><\/p>\n

—————————————————————- —————-
\n<\/span><\/p>\n

IM transactions 2
\n<\/span><\/p>\n

IM transactions rows journaled 10100
\n<\/span><\/p>\n

IM populate segments requested 1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uc138\uadf8\uba3c\ud2b8\uc758 population \uc0c1\ud0dc\ub97c \ud655\uc778\ud574 \ubcf4\uba74 \uc18c\ub7c9\uc758 \ub370\uc774\ud130\ub9cc\uc744 \ucd94\uac00\ub85c \uc785\ub825\ud588\uae30 \ub54c\ubb38\uc5d0(100\uac74) \uc2e0\uaddc\ub85c \ud560\ub2f9\ub41c \uc775\uc2a4\ud150\ud2b8\ub098 \ube14\ub85d\uc740 \uc5c6\uace0, \uc774\ubbf8 \ud560\ub2f9\ub41c \uc775\uc2a4\ud150\ud2b8 \ub0b4\uc5d0 \ub370\uc774\ud130\uac00 \ucd94\uac00\ub41c \ucf00\uc774\uc2a4\ub77c\uace0 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4 (\uae30\uc874 \uac12\uacfc \ube44\uad50) \uc774\ub294 trickle repopulation \ub300\uc0c1\uc785\ub2c8\ub2e4<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select a.object_name, b.membytes, b.extents, b.blocks,
\n<\/span><\/span><\/p>\n

b.datablocks, b.blocksinmem, b.bytes
\n<\/span><\/p>\n

from v$im_segments_detail b, dba_objects a
\n<\/span><\/p>\n

where a.data_object_id = b.dataobj
\n<\/span><\/p>\n

and a.object_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

OBJECT_NAME MEMBYTES EXTENTS BLOCKS DATABLOCKS BLOCKSINMEM BYTES
\n<\/span><\/p>\n

——————– ———- ———- ———- ———- ———– ———-
\n<\/span><\/p>\n

SALES1 1179648 7 56 50 50 458752<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

v$im_segments\uc5d0\uc11c BYTES_NOT_POPULATED \uc218\uce58\uac00 0\uc73c\ub85c \ub098\ud0c0\ub098\ub294 \uc774\uc720\ub294 BYTES_NOT_POPULATED \uac00 \uc138\uadf8\uba3c\ud2b8\uc5d0 \ucd94\uac00\ub418\uc5c8\uc73c\ub098 \uc544\uc9c1 population \ub418\uc9c0 \uc54a\uc740 \uc2e0\uaddc \uc775\uc2a4\ud150\ud2b8\uc758 \uc0ac\uc774\uc988\ub9cc\uc744 \ub098\ud0c0\ub0b4\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated
\n<\/span><\/span><\/p>\n

from v$im_segments where segment_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 458752 1179648 0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\ucd94\uac00\ub41c \ub85c\uc6b0\uc758 population \uc815\ubcf4\ub294 v$im_header \ubdf0\uc5d0\uc11c \uad00\ub828 \uc815\ubcf4\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. \ud604\uc7ac \ub2e4\uc74c \uac19\uc740 \uc0c1\ud0dc\uc784\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\ub098\uc758 IMCU \ub9cc \uc0dd\uc131\ub418\uc5b4 \uc788\uc73c\uba70 (v$im_header\uc5d0\ub294 IMCU 1\uac1c\ub2f9 1\uac1c \ub85c\uc6b0 \uc0dd\uc131) 7\uac1c \ub514\uc2a4\ud06c \uc775\uc2a4\ud150\ud2b8, 50\uac1c \ube14\ub85d\uc5d0 \uc800\uc7a5\ub41c 10100\uac1c\uc758 \ub85c\uc6b0\uac00 \ub9e4\ud551\ub418\uc5b4 \uc788\uc74c IMCU\uc5d0 \ub9e4\ud551\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

Tricke repopulation\uc774 \ubc1c\uc0dd\ud588\uc74c (REPOPULATED 1, TRICKLE_REPOPULATED 1)<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select b.object_name, a.prepopulated, a.repopulated,
\n<\/span><\/span><\/p>\n

a.trickle_repopulated, a.num_disk_extents, a.num_blocks,
\n<\/span><\/p>\n

a.num_rows, a.num_cols
\n<\/span><\/p>\n

from v$im_header a, dba_objects b
\n<\/span><\/p>\n

where a.objd = b.data_object_id
\n<\/span><\/p>\n

and b.object_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

OBJECT_NAME PREPOPULATED REPOPULATED TRICKLE_REPOPULATED NUM_DISK_EXTENTS NUM_BLOCKS NUM_ROWS NUM_COLS
\n<\/span><\/p>\n

——————– ———— ———– ——————- —————- ———- ———- ———-
\n<\/span><\/p>\n

SALES1 0 1 1 7 50 10100 7<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Data Loads \u2013 \uc2dc\ub098\ub9ac\uc624 3<\/h4>\n

\uc774\ubc88\uc5d0\ub294 append \ud78c\ud2b8\ub97c \uc0ac\uc6a9\ud558\uc5ec direct path insert\ub97c \ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. Repopulation\uc774 \ud544\uc694\ud55c \uc0c8\ub85c\uc6b4 extents \ud560\ub2f9\uc774 \uc774\ub8e8\uc5b4\uc9c4 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. 49 \ube14\ub85d (99-50) \uc774 IM Column Store\uc5d0 \uc544\uc9c1 popuation \uc548\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> insert \/*+ append *\/ into sales1 select * from sales where rownum <= 10000;<\/span>
\n<\/span><\/p>\n

10000 rows created.
\n<\/span><\/p>\n

SQL> commit;
\n<\/span><\/span><\/p>\n

Commit complete.
\n<\/span><\/p>\n

SQL> select a.object_name, b.membytes, b.extents, b.blocks,
\n<\/span><\/span><\/p>\n

b.datablocks, b.blocksinmem, b.bytes
\n<\/span><\/p>\n

from v$im_segments_detail b, dba_objects a
\n<\/span><\/p>\n

where a.data_object_id = b.dataobj
\n<\/span><\/p>\n

and a.object_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

OBJECT_NAME MEMBYTES EXTENTS BLOCKS DATABLOCKS BLOCKSINMEM BYTES
\n<\/span><\/p>\n

——————– ———- ———- ———- ———- ———– ———-
\n<\/span><\/p>\n

SALES1 1179648 14 112 99 50 917504<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

v$im_segments\uc758 BYTES_NOT_POPULATED \uac12\uc740 SALES1 \ud14c\uc774\ube14\uc774 \uc644\uc804\ud788 population \ub418\uc9c0 \uc54a\uc558\uc74c\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated
\n<\/span><\/p>\n

from v$im_segments where segment_name = ‘SALES1’;
\n<\/span><\/p>\n

2
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 917504 1179648 401408<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uc218\ub3d9\uc73c\ub85c population\uc744 \ud569\ub2c8\ub2e4<\/p>\n

force \uc635\uc158\uc744 false\ub85c \ud558\uace0 repopulate \ud504\ub85c\uc2dc\uc800\ub97c \uc218\ud589\ud55c \ud6c4 population \uc0c1\ud0dc\ub97c \ud655\uc778\ud574 \ubcf4\uba74 population\uc774 \uc544\uc9c1 \uc218\ud589\ub418\uc9c0 \uc54a\uc558\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 force=>false \uc635\uc158\uc774 IMCU \ub0b4 \ubcc0\uacbd\ub41c \ub370\uc774\ud130\ub9cc (\uc2e0\uaddc IMCU\uac00 \uc544\ub2c8\ub77c) population \uc2dc\ud0a4\ub294 \uc635\uc158\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> execute dbms_inmemory.repopulate(‘LABUSER’, ‘SALES1’, null, force=>false);<\/span>
\n<\/span><\/p>\n

PL\/SQL procedure successfully completed.
\n<\/span><\/p>\n

SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated
\n<\/span><\/span><\/p>\n

from v$im_segments where segment_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 917504 1179648 401408<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

false\uc635\uc158\uc744 true\ub85c \ud574\uc11c \uc218\ub3d9\uc73c\ub85c population \uc2dc\ud0b5\ub2c8\ub2e4. False=>true\uc778 dbms_inmemory.repopulate \ud504\ub85c\uc2dc\uc800\ub294 populate \ud504\ub85c\uc2dc\uc800\uc640 \ub3d9\uc77c\ud558\uac8c \ub3d9\uc791\ud569\ub2c8\ub2e4. (population \ub418\uc9c0 \uc54a\uc740 \ub514\uc2a4\ud06c \uc775\uc2a4\ud150\ud2b8\ub97c \uac15\uc81c\ub85c population \uc2dc\ud0b4)<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> execute dbms_inmemory.repopulate(‘LABUSER’, ‘SALES1’, null, force=>true);
\n<\/span><\/span><\/p>\n

PL\/SQL procedure successfully completed.
\n<\/span><\/p>\n

SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated
\n<\/span><\/span><\/p>\n

from v$im_segments where segment_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 917504 1179648 0<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Data Loads \u2013 \uc2dc\ub098\ub9ac\uc624 4<\/h4>\n

\uc774\ubc88\uc5d0\ub294 priority \uc18d\uc131\uc744 high\ub85c \ubcc0\uacbd \ud6c4 direct path load \ub97c \uc218\ud589\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \ud14c\uc774\ube14 priority \ubcc0\uacbd \ud6c4, BYTES_NOT_POPULATED \uc774 0\uc73c\ub85c population \uc644\ub8cc \ub41c \uac83\uc744 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> alter table sales1 inmemory priority high;<\/span>
\n<\/span><\/p>\n

Table altered.
\n<\/span><\/p>\n

SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated from v$im_segments where segment_name =’SALES1′;<\/span>
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 917504 1179648 0<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Direct path load\ub85c \ub370\uc774\ud130 \uc785\ub825 \ud6c4 v$im_segments\ub97c \uc870\ud68c\ud574 \ubcf4\uba74, \uc5b4\ub290 \uc815\ub3c4 \uc2dc\uac04\uc774 \uc9c0\ub09c \ud6c4 (\uc218\ucd08 ~ 1\ubd84) dbms_inmemory.repopulate \ud504\ub85c\uc2dc\uc800 \uc2e4\ud589\uc774\ub098 SALES1 \ud14c\uc774\ube14 \uc870\ud68c\uc640 \uac19\uc740 \ubcc4\ub3c4\uc758 \uc870\uce58 \uc5c6\uc774\ub3c4 population\uc774 \uc774\ub8e8\uc5b4 \uc9c4 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> insert \/*+ append *\/ into sales1 select * from sales where rownum <= 10000;<\/span>
\n<\/span><\/p>\n

10000 rows created.
\n<\/span><\/p>\n

SQL> commit;<\/span>
\n<\/span><\/p>\n

Commit complete.
\n<\/span><\/p>\n

SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated
\n<\/span><\/span><\/p>\n

from v$im_segments where segment_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 2097152 1179648 401408<\/span>
\n<\/span><\/p>\n

SQL> select segment_name, populate_status, bytes, inmemory_size, bytes_not_populated from v$im_segments where segment_name = ‘SALES1’;<\/span>
\n<\/span><\/p>\n

SEGMENT_NAME POPULATE_ BYTES INMEMORY_SIZE BYTES_NOT_POPULATED
\n<\/span><\/p>\n

——————– ——— ———- ————- ——————-
\n<\/span><\/p>\n

SALES1 COMPLETED 2097152 1179648 0<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

In-Memory Column Store DML \ucc98\ub9ac IM Column Store\uc5d0\uc11c\uc758 DML \ucc98\ub9ac\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. Data Loads \u2013 \uc2dc\ub098\ub9ac\uc624 1 \uccab\ubc88\uc9f8 \uc2dc\ub098\ub9ac\uc624\ub294 SALES1 \ud14c\uc774\ube14\uc744 \ub514\ud3f4\ud2b8 priority\ub85c \uc0dd\uc131\ud558\uace0 non-direct path data load \uc218\ud589\ud588\uc744 \ub54c\uc785\ub2c8\ub2e4. [oracle@New-Features-12c ~]$ sqlplus labuser\/labuser@pdb1 SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 28 11:36:05 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Last Successful login time: […]<\/p>\n","protected":false},"author":1,"featured_media":2336,"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":[20],"tags":[758,1105],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/Oracle-12c-logo-New.png?fit=499%2C302","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4010"}],"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=4010"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4010\/revisions"}],"predecessor-version":[{"id":4012,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4010\/revisions\/4012"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2336"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4010"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}