Slide 52
Slide 52 text
利⽤イメージ
• INMEMORY(ALL) NO INMEMORY の例 • NO INMEMORY(ALL) INMEMORY の例
選択しやすいインメモリ列
Copyright © 2023, Oracle and/or its affiliates
52
SQL> create table tab01 (c1 number, c2 number, c3 number);
SQL> ALTER TABLE tab01 INMEMORY;
SQL> ALTER TABLE tab01 NO INMEMORY(ALL) INMEMORY(c1, c2);
SQL> select table_name,column_name,inmemory_compression
2 from v$im_column_level;
TABLE_NAME COLUMN_NAME INMEMORY_COMPRESSION
--------------- --------------- -------------------
TAB01 C1 DEFAULT
TAB01 C2 DEFAULT
TAB01 C3 NO INMEMORY
SQL> SELECT inmemory_compression compress, populate_status status,
2 bytes/1024/1024 "orig_size(MB)",
3 inmemory_size/1024/1024 "inmem_size(MB)",
4 bytes_not_populated not_populate
5 FROM v$im_segments where segment_name = 'TAB01';
COMPRESS STATUS orig_size(MB) inmem_size(MB) NOT_POPULATE
------------- --------- ------------- -------------- ------------
FOR QUERY LOW COMPLETED 18.640625 14.4375 0
SQL> create table tab01 (c1 number, c2 number, c3 number);
SQL> ALTER TABLE tab01 INMEMORY;
SQL> ALTER TABLE tab01 INMEMORY(ALL) NO INMEMORY(c1, c2);
SQL> select table_name,column_name,inmemory_compression
2 from v$im_column_level;
TABLE_NAME COLUMN_NAME INMEMORY_COMPRESSION
--------------- --------------- -------------------
TAB01 C1 NO INMEMORY
TAB01 C2 NO INMEMORY
TAB01 C3 DEFAULT
SQL> SELECT inmemory_compression compress, populate_status status,
2 bytes/1024/1024 "orig_size(MB)",
3 inmemory_size/1024/1024 "inmem_size(MB)",
4 bytes_not_populated not_populate
5 FROM v$im_segments where segment_name = 'TAB01';
COMPRESS STATUS orig_size(MB) inmem_size(MB) NOT_POPULATE
------------- --------- ------------- -------------- ------------
FOR QUERY LOW COMPLETED 18.640625 4.4375 0