ORACLE 12C In-Memory组件学习笔记

12.1.0.2版本
[oracle@localhost ~]$ sqlplus chf/xifenfei@pdb1
 
SQL*Plus: Release 12.1.0.2.0 Beta on Thu Apr 24 21:39:43 2014
 
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Beta
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
SQL> select * from v$version;
 
BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Beta                    0
PL/SQL Release 12.1.0.2.0 - Beta                                                          0
CORE    12.1.0.2.0      Beta                                                              0
TNS for Linux: Version 12.1.0.2.0 - Beta                                                  0
NLSRTL Version 12.1.0.2.0 - Beta                                                          0
关于In-Memory组件
SQL>  select parameter,value from v$option where parameter like 'In-Memory%'
 
PARAMETER                                                        VALUE
---------------------------------------------------------------- -------------
In-Memory Column Store                                           TRUE
In-Memory Aggregation                                            TRUE
关于inmemory参数
SQL> select NAME,value,DESCRIPTION from v$parameter where NAME like 'inmemory%'
 
NAME                 VALUE
-------------------- --------------------
DESCRIPTION
---------------------------------------------------
inmemory_size        0
size in bytes of in-memory area
 
inmemory_clause_defa
ult
Default in-memory clause for new tables
 
inmemory_force       DEFAULT
Force tables to be in-memory or not
 
inmemory_query       ENABLE
Specifies whether in-memory queries are allowed
启用In-Memory功能
SQL> show parameter inmemory;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
inmemory_clause_default              string
inmemory_force                       string      DEFAULT
inmemory_query                       string      ENABLE
inmemory_size                        big integer 0
 
SQL> alter system set inmemory_size=200M scope=spfile;
 
System altered.
 
SQL> shutdown immediate
Pluggable Database closed.
SQL> startup
Pluggable Database opened.
SQL> show parameter inmemory;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------
inmemory_clause_default              string
inmemory_force                       string      DEFAULT
inmemory_query                       string      ENABLE
inmemory_size                        big integer 200M
创建测试表
SQL> create table t_xifenfei_in_memory as select * from dba_objects;
 
Table created.
 
SQL> select TABLE_NAME,INMEMORY_PRIORITY,INMEMORY_DISTRIBUTE,INMEMORY_COMPRESSION from user_tables;
 
TABLE_NAME                     INMEMORY INMEMORY_DISTRI INMEMORY_COMPRESS
------------------------------ -------- --------------- -----------------
T_XIFENFEI_IN_MEMORY
 
SQL> alter table  T_XIFENFEI_IN_MEMORY inmemory;
 
Table altered.
 
SQL> select TABLE_NAME,INMEMORY_PRIORITY,INMEMORY_DISTRIBUTE,INMEMORY_COMPRESSION from user_tables;
 
TABLE_NAME                INMEMORY INMEMORY_DISTRI INMEMORY_COMPRESS
------------------------- -------- --------------- -----------------
T_XIFENFEI_IN_MEMORY      NONE     AUTO DISTRIBUTE FOR QUERY

联系：手机(13429648788) QQ(107644445)
原文来自:http://www.xifenfei.com/5259.html
作者：惜分飞