The fourth chapter is about enabling and disabling the im column storage of table space for im enabled filling objects (IM 4.5)

In-Memory The manual : Preface （IM- Preface ）

Chapter one Oracle Database In-Memory Relevant concepts (IM-1.1)

Chapter one Oracle Database In-Memory Relevant concepts （ To continue ）(IM-1.2)

Chapter two Oracle Database In-Memory Architecture ( On ) (IM-2.1)

Chapter two In-Memory Architecture (IM-2.2)

Chapter two IM Architecture ：CPU framework ：SIMD Vector processing （IM-2.3）

The third chapter Enable and adjust IM The size of the column store （IM-3.1）

Chapter four by In-Memory Enable fill objects （IM-4.1 The first part ）

Chapter four by In-Memory Enable fill objects （IM-4.2 The second part ）

Chapter four by IM Enable and disable columns for fill objects （IM-4.3 The third part ）

Chapter four by IM Enables the placement of fill objects NO INMEMORY The table specifies INMEMORY Column properties ： Example （IM-4.4 The fourth part ）

Enables and disables the of tablespaces IM Column store

You can enable or disable IM The tablespace stored by the column .

You can use include during tablespace creation INMEMORY Clause CREATE TABLESPACE Statement for IM Column repositories enable tablespaces . You can also use include INMEMORY Clause ALTER TABLESPACE Statement to change the tablespace to enable IM Column store .

By means of CREATE TABLESPACE or ALTER TABLESPACE The statement contains NO INMEMORY Clause , You can disable IM The tablespace stored by the column .

by IM When tablespaces are enabled for column storage , By default it will be IM Column storage enables all tables and materialized views in the tablespace .INMEMORY Clause for table , Instantiated views and tablespaces are the same . For IM When tablespaces are enabled for column storage , Disabled at IM Before the tablespace stored by the column , stay INMEMORY Before clause and NO INMEMORY Before clause , Need to be DEFAULT Clause .

by IM When tablespaces are enabled for column storage , Individual tables and materialized views in a tablespace can have different memory settings , The setting of a single database object overrides the setting of the tablespace . for example , If the tablespace is set to PRIORITY LOW Used to fill the data in memory , But the table in the tablespace is set to PRIORITY HIGH, Then the table is used PRIORITY HIGH.

To enable or disable IM The tablespace stored by the column , Please complete the following steps ：

1. Make sure that... Is enabled for the database IM Column store .

Please see the “ Enable... For the database IM Column store ”.

1. Connect to the database instance as a user with appropriate privileges , To create or change a tablespace .
2. Running has INMEMORY Clause or NO INMEMORY Clause CREATE TABLESPACE or ALTER TABLESPACE sentence .

Example 4-12 Create a tablespace and enable IM Column store

The following example creates users01 Table space , And enable IM Column store ：

CREATE TABLESPACE users01 

   DATAFILE 'users01.dbf' SIZE 40M 

   ONLINE

   DEFAULT INMEMORY;

This sample uses INMEMORY The default value of the clause . therefore , Use MEMCOMPRESS FOR QUERY , And use PRIORITY NONE.

Example 4-13 Change the tablespace to enable IM Column store

The following example changes users01 Tablespaces to enable IM Column store , Specify... For database objects in a tablespace FOR CAPACITY HIGH Compress , And fill the data in memory PRIORITY LOW：

ALTER TABLESPACE users01 DEFAULT INMEMORY 

   MEMCOMPRESS FOR CAPACITY HIGH 

   PRIORITY LOW;

Shandong Oracle User group (Shandong Oracle User Group), abbreviation ：SDOUG, Is a full of vitality 、 Young non-profit organizations , It aims to provide an exchange platform for technology lovers in Jinan and surrounding areas .SDOUG Organize offline technology sharing activities from time to time , Promote local and surrounding IT Technological development 、 Help technology enthusiasts improve themselves . Share technology 、 Share happiness ,SDOUG On the road .