Chapter 4 is a tutorial on forced filling of in memory objects with IM enabled filling objects (IM 4.7)

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 ）

Chapter four by IM Enable and disable tablespaces for padding objects IM Column store （IM 4.5）

Chapter four Enable and disable... For materialized views IM Column store （IM 4.6）

This article is IM Chapter 4 of the series ： by IM Enables forced filling of filled objects In-Memory object ： course （IM 4.7）

Force fill In-Memory object ： course

Enable In-Memory A filled object does not immediately fill the object .

If enabled PRIORITY Set to NONE The object of , And if you want to fill the object immediately , You can use the following options ：

· Force full table scan

· Use DBMS_INMEMORY.POPULATE stored procedure

hypothesis

This tutorial assumes the following ：

· IM Column storage is enabled .

· for sh.customers Table enable In-Memory fill , Use the default PRIORITY by NONE.

· You want to force sh.customers Immediately fill to IM Column storage .

Force fill INMEMORY surface ：

1. stay SQL * Plus or SQLDeveloper in , Log in to the database with administrator privileges .

2. take INMEMORY Property is applied to the table .

for example , by sh.customers Enable IM Fill as follows ：

ALTER TABLE sh.customers INMEMORY;

3. （ Optional ） Check the filling status , Please check V$IM_SEGMENTS View .

for example , Use the following statement （ Contains sample output ）：

SELECT OWNER, SEGMENT_NAME NAME,

       POPULATE_STATUS STATUS

FROM   V$IM_SEGMENTS

WHERE  SEGMENT_NAME = 'CUSTOMERS';

no rows selected

The above output shows that it has not been in IM Fill objects in the column store .

4. Execute on table DBMS_INMEMORY.POPULATE stored procedure .

for example , in the light of sh.customers Enable this stored procedure , As shown below ：

EXEC DBMS_INMEMORY.POPULATE('SH', 'CUSTOMERS');

5. （ Optional ） To check the filling status , Please check V$IM_SEGMENTS View .

for example , Use the following statement （ Contains sample output ）：

SELECT OWNER, SEGMENT_NAME NAME,

       POPULATE_STATUS STATUS

FROM   V$IM_SEGMENTS

WHERE  SEGMENT_NAME = 'CUSTOMERS';

OWN NAME       STATUS

--- ---------- --------------------

SH  CUSTOMERS  COMPLETED

Now? , The object has been populated to IM Column storage .

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 .