ORACLE 12C in-memory Component Learning Notes

12.1.0.2 version
[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
About the In-memory component
Sql> Select Parameter,value from v$option where parameter like ' in-memory% '

PARAMETER VALUE
---------------------------------------------------------------- -------------
In-memory Column Store TRUE
In-memory Aggregation TRUE
About InMemory Parameters
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 is in-memory or not

Inmemory_query ENABLE
Specifies whether In-memory queries are allowed
Enable In-memory Features
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
To create a test table
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

Contact: Mobile Phone (13429648788) QQ (107644445)
Original from: http://www.xifenfei.com/5259.html
Author: Xi-FEI