Oracle Database 12c new features: In-memory Option

The thousands of expected Oracle In-memory options are included in the version of Oracle 12.1.0.2 . Now that Otn has provided the download to begin with, the current major version is the Linux x86 and Solaris Platform, the software installation process is similar to the previous version, this article begins with a new installation,DBCA After building the library, we look at the in memory to provide those parameters for configuration:

Sql> Show parameter inmemory;

NAME TYPE VALUE

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

Inmemory_clause_default string

Inmemory_force string DEFAULT

Inmemory_max_populate_servers integer 0

Inmemory_query string ENABLE

Inmemory_size Big Integer 0

Inmemory_trickle_repopulate_servers_ Integer 1

Percent

Optimizer_inmemory_aware Boolean TRUE

inmemory_sizeDefines thein-memoryThe size,defaultFor0MB，Inmemory_forceDefineddefault's Behavior,defaultIndicates that only theDDLDefined before it is placed in thein-memory AreaInoffRepresents the closingin-memory Area。Inmemory_clause_defaultDefines whether a new table is automatically added to thein-memory Area, compression and other genera.
Optimizer_inmemory_awareSaidOptimizerWhether theinmemorySupport. Inmemory_sizeis a static parameter, the change requires that the instance be restarted to take effect.

provided to in memory is used from SGA is allocated in the space, dividing a single area of memory to . Called in-memory area , in-memory   the larger the memory area, the better, so that more data is stored in memory, amm or asmm to manage is essentially an extra chunk of memory in the DDL definition and is placed in Region You can modify the behavior by inmemory_clause_default

For example, manually put the table in the in-memory area

Sql> CREATE TABLE TBS1 (a int,b int);

Table created.

sql> ALTER TABLE TBS1 inmemory;

Table altered.

Cancel table stored in inmemory

sql> ALTER TABLE TBS1 no inmemory;

Table altered.

You can also define which column to place in the in-memory area at the field level

sql> ALTER TABLE test1 InMemory;

Table altered.

sql> ALTER TABLE Test1 inmemory (name) no inmemory (Mark);

Table altered.

Oracle Database 12c new features: In-memory Option