User interface and im expression (IM 5.6)

Upper connection IM 5.5. This chapter is IM Chapter 5 of the series Use In-Memory Expression optimization query part 6 user interface and IM expression .

User interface and IM expression

DBMS_INMEMORY_ADMIN package ,DBMS_INMEMORY Bao He INMEMORY_EXPRESSIONS_USAGE Initialization parameter control IM The behavior of an expression .

This section contains the following topics ：

• INMEMORY_EXPRESSIONS_USAGE INMEMORY_EXPRESSIONS_USAGE i The initialization parameters determine the population IM The type of expression .INMEMORY_VIRTUAL_COLUMNS initialization Parameter control is normal （ Non hidden ） Population of virtual columns .
• DBMS_INMEMORY_ADMIN and DBMS_INMEMORY To manage IM expression , Please use DBMS_INMEMORY_ADMIN and DBMS_INMEMORY package .

INMEMORY_EXPRESSIONS_USAGE

INMEMORY_EXPRESSIONS_USAGE i The initialization parameters determine the population IM The type of expression . INMEMORY_VIRTUAL_COLUMNS Initialization parameter control is normal （ Non hidden ） Population of virtual columns .

When you enable IM Column store (INMEMORY_SIZE Not for 0) when , INMEMORY_EXPRESSIONS_USAGE Controls how the database is populated IM The type of expression .INMEMORY_EXPRESSIONS_USAGE Initialization parameters have the following options ：

· ENABLE

The database will be static and dynamic IM Fill the expression to IM Column storage . Setting this value will increase the memory consumption of some tables . This is the default .

· STATIC_ONLY

Static configuration makes IM Column storage can cache data IS_JSON Check the of constraints OSON（ Binary system JSON） Column . In the internal ,OSON The column is named SYS_IME_OSON Hidden virtual columns .

· DYNAMIC_ONLY

The database is only populated as SYS_IME Hidden virtual columns are added to common or “ heat ” expression . Setting this value will increase the memory consumption of some tables .

· DISABLE

The database will not IM expression （ Whether static or dynamic ） All filled to IM Column storage .

notes :

IM Expressions that depend on... Are not supported NLS Data type of .

change INMEMORY_EXPRESSIONS_USAGE The value of is right IM The currently populated in the column store IM The expression will not take effect immediately . for example , If you will INMEMORY_EXPRESSIONS_USAGE from DYNAMIC_ONLY Change to DISABLE, The database will not delete the stored data immediately IM expression . contrary , The next reordering will exclude disabled IM expression , So as to effectively delete them .

DBMS_INMEMORY_ADMINand DBMS_INMEMORY

To manage IM expression , Please use DBMS_INMEMORY_ADMIN and DBMS_INMEMORY package .

Used to manage IM Of expression PL / SQL stored procedure

Used to manage IM Of expression PL / SQL stored procedure

To be continued .

Here are IM Content of series articles ：

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）

Chapter four by IM Enables forced filling of filled objects In-Memory object ： course （IM 4.7）

Chapter four by IM Enable fill objects to IM Column storage enabled ADO（IM 4.8）

The fifth chapter Use In-Memory Expression optimization query （IM 5.1）

IM The purpose of the expression （IM 5.2）

IM How expressions work （IM 5.3）

How to fill the database IM expression （IM 5.4）

IMEU How to communicate with IMCU Related to （IM 5.5）

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 .