Index

A

Active Data Guard
- about 11.1
- how IM column store works 11.1.2
- purpose 11.1.1, 11.1.1.1
Active Session History (ASH) 1.6.1
advisors
- In-Memory Advisor 1.6.1
- Oracle Compression Advisor 1.6.3, 3.2
ALL_HEAT_MAP_SEGMENT view 4.7.3.1
ALL_JSON_COLUMNS view 5.1.2.1
ALTER MATERIALIZED VIEW statement 4.1.3.1, 4.5
ALTER TABLESPACE statement 4.1.3.1
ALTER TABLE statement 2.2.1.1, 4.1.3.1, 4.1.3.3, 4.2.2
analytic indexes 1.3.3
analytic queries 1.1, 1.3, 1.3.2, 1.3.2.1, 1.3.3
Auto DOP 10.1.3.2
Automatic Data Optimization (ADO)
- Heat Map 4.7.3.1
- how policies work 4.7.3.2
- In-Memory Column Store 4.7.5
- policies 4.7.1
- purpose 4.7.2
- user interface 4.7.4

B

Bloom filters 1.3.2.2, 6.1, 7.2, 7.3.1

C

columnar data pool 2.1.1.2
columnar format 2, 2.1, 2.2.1
- benefits 1.3.2.1
- single-format approach 1.2
Column Compression Units (CUs)
- FastStart area 9.1.2.1
- local dictionary 2.2.1.2
- row modifications 8.2.1
common dictionaries 6.4.1
COMPATIBLE initialization parameter 3.3, 4.3.1, 4.3.2, 4.7.4
compression 3.2
- affect on repopulation 8.3.2
- Hybrid Columnar Compression 2.2.1.1.1
- In-Memory Column Store 2.2.1.1.1
- methods 4.1.3.3
conventional DML 8.2.1
CPU_COUNT initialization parameter 4.1.2.2
CPU architecture 8.5
- SIMD vector processing 1.3.2.1, 7.2
CREATE MATERIALIZED VIEW statement 4.1.3.1, 4.5
CREATE TABLE AS SELECT statement 8.2.2
CREATE TABLESPACE statement 4.1.3.1
CREATE TABLE statement 4.1.3.1, 4.1.3.3
CUs
- See: Column Compression Units (CUs)

D

database buffer cache 2.1.2
Database In-Memory 1.3
- about 1.3.1
- introduction 1
- principal tasks 1.5
- tools for 1.6
database instances
- multiple IM column stores 10.1.1
data flow operator (DFO) 7.3
data loading, into IM column store 8.2
DBA_EXPRESSION_STATISTICS view 13
DBA_FEATURE_USAGE_STATISTICS view 13
DBA_HEAT_MAP_SEGMENT view 4.7.1, 13
DBA_ILMDATAMOVEMENTPOLICIES view 13
DBA_IM_EXPRESSIONS view 5.1, 13
DBA_JOINGROUPS view 13
DBA_TABLES view 4.1.3.1, 10.1.2.1, 13
DBMS_COMPRESSION PL/SQL package 3.2, 4.1.3.4
DBMS_HEATMAP PL/SQL package 4.7.4
DBMS_ILM_ADMIN PL/SQL package 4.7.4
DBMS_ILM PL/SQL package 4.7.4, 4.7.5
DBMS_INMEMORY_ADMIN package 5.1, 5.1.2.2, 5.1.3.2, 5.1.4, 5.3, 5.4, 9.1.2, 9.4
- FASTSTART_DISABLE procedure 9.5
DBMS_INMEMORY package 5.1, 5.1.3.2, 5.4
- REPOPULATE procedure 8.4
DBMS_INMEMORY procedure
- REPOPULATE procedure 8.3
DBMS_SQLTUNE PL/SQL package 6.6
dense keys 7.3.2
- dense grouping keys 7.3, 7.3.2
- dense join keys 7.3.2
dictionaries
- common 6.4.1
- local 2.2.1.2.2
direct path loads
- into IM column store 8.2.2
DISTRIBUTE clause of CREATE TABLE 10.1.2, 10.1.2.1, 10.1.2.1.1, 10.1.2.1.2, 10.1.2.1.3
DISTRIBUTE FOR SERVICE subclause of CREATE TABLE 10.2.2, 11.2
DML
- conventional 8.2.1
- direct path loads 8.2.2
- double buffering 8.2.1.2
- staleness threshold 8.2.1.1
double buffering 8.2.1.2, 8.3.2
DUPLICATE clause of CREATE TABLE 10.1.2, 10.1.2.2, 10.1.2.2.1, 10.1.2.2.2, 10.1.4, 10.2.3
duplication, Oracle RAC 10.1.2.2, 10.1.2.2.1, 10.1.2.2.2, 10.1.2.2.3

E

Enterprise Manager Cloud Control (Cloud Control) 1.6.2
expressions, In-Memory 2.2.3, 5, 5.1.3.1
Expression Statistics Store (ESS) 2.2, 2.3, 5.1.2.3

F

FASTSTART_DISABLE procedure 9.5
FASTSTART_ENABLE procedure 9.1.2, 9.2
FASTSTART_MIGRATE_STORAGE procedure 9.4
FastStart area 9.1.2.1, 9.1.2.2
- disabling 9.5
- migrating 9.4
FOR SERVICE subclause of CREATE TABLE 10.2.4

G

granules 2.2.1.1.2

H

HEAT_MAP initialization parameter 4.7.4
Heat Map 4.7.2, 4.7.3.1
High Availability 1.3.4
- benefits of the DUPLICATE ALL clause 10.1.2.2.2
- benefits of the NO DUPLICATE clause 10.1.2.2.3
- IM column store
hints
- VECTOR_TRANSFORM_DIMS 7.4
- VECTOR_TRANSFORM_FACT 7.4
Hybrid Columnar Compression 2.2.1.1.1

I

ILM clause of ALTER TABLE 4.7.5
IMCO
- See: In-Memory Coordinator Process (IMCO)
IM column store
- See: In-Memory Column Store In-Memory Column Store
IMCU
- See: In-Memory Compression Units (IMCUs)
IME_CAPTURE_EXPRESSIONS procedure 5.1.2.4, 5.1.3.2, 5.3
IME_DROP_ALL_EXPRESSIONS procedure 5.1.2.2, 5.1.3.2, 5.4
IME_DROP_EXPRESSIONS procedure 5.1.2.2, 5.1.3.2, 5.4
IME_POPULATE_EXPRESSIONS procedure 5.1.3.2
IMEUs
- See: In-Memory Expression Units (IMEUs)
IM expressions 5.1, 5.1.2
- administering 5.1.3.2
- basic tasks 5.1.4
- benefits 5.1.1
- capturing 5.1.2.2, 5.3
- configuring 5.2
- dropping 5.4
- Expression Statistics Store (ESS) 2.3, 5.1.2.3
- JSON columns 5.1.3.1
- JSON optimizations 5.1.2.1
- materialized views 5.1.1
- modes of operation 5.1.3.1
- overview 2.2.3, 5
- populating 5.3
- population 5.1.2.4
- storage in IMEUs 5.1.2.5
- user interfaces 5.1.3
- virtual columns 5.1.2.1
IM FastStart
- See: In-Memory FastStart
IM storage indexes 2.2.1.3
indexes, analytic 1.3.3
INMEMORY_CLAUSE_DEFAULT initialization parameter 12
INMEMORY_EXPRESSIONS_USAGE initialization parameter 5.1.2.1, 5.1.2.4, 5.1.3.1, 5.1.4, 5.2, 12
INMEMORY_FORCE initialization parameter 12
INMEMORY_MAX_POPULATE_SERVERS initialization parameter 4.1.2.2, 8.3.1, 8.4, 12
INMEMORY_QUERY initialization parameter 12
INMEMORY_SIZE initialization parameter 1.3.5, 2.1.1.1, 3.1, 3.3, 3.4, 3.5, 4.7.4, 4.7.5, 5.1.3.1, 5.2, 7.1, 10.2.4, 11.1.1.1, 11.1.1.2, 11.1.1.3, 12
INMEMORY_TRICKLE_POPULATE_SERVERS_PERCENT initialization parameter 12
INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT initialization parameter 8.3.1, 8.3.2, 8.4, 8.5
INMEMORY_VIRTUAL_COLUMNS initialization parameter 4.3.1, 4.3.2, 5.1.2.4, 12
In-Memory Advisor 1.6.1
In-Memory Aggregation 1.3.1, 1.3.2.3, 7, 7.2.2
- about 7.1
- controls 7.4
- how it works 7.3
- phases 7.3.3
- purpose 7.2
- scenario 7.3.4
- when it occurs 7.3.1
In-Memory Area
- columnar data pool 2.1.1.2
- estimating size 3.2
- metadata pool 2.1.1.2
- setting size 3.3
- size 2.1.1.1
- Snapshot Metadata Units (SMUs) 2.2.2.1
INMEMORY clause of ALTER TABLE 4.2.2, 11.1.1.1, 11.1.1.2, 11.1.1.3
INMEMORY clause of CREATE TABLE 4.2.1
INMEMORY clause of CREATE TABLESPACE 4.4
In-Memory Column Store 1
- about 1.1
- Active Data Guard 11.1, 11.1.1, 11.1.1.1, 11.1.1.2, 11.1.1.3
- advantages 1.3
- and Oracle RAC 10.1
- architecture 2.2
- Automatic Data Optimization 4.7.5
- benefits 1.3.5
- columnar format 2
- compression 2.2.1.1.1, 4.1.3.3
- compression units 1.3.2.1, 2.2.1
- consistency with buffer cache 2.1.2
- disabling 3.5
- disabling tables 4.2.2
- dual memory formats 2.1, 2.1.2
- enabling existing tables 4.2.2
- enabling for a database 3.3
- enabling for materialized views 4.5
- enabling for tablespaces 4.4
- enabling new tables 4.2.1
- estimating size 3.2
- FastStart tablespace 9.1.2
- High Availability
- IM expressions 2.2.3, 5, 5.1, 5.1.1, 5.1.2.2, 5.1.3.1
- IM FastStart 9.1.1, 9.2, 9.3, 9.4, 9.5
  - about 9.1
- IM storage indexes 2.2.1.3
- increasing dynamically 3.4
- initialization parameters 12
- In-Memory Advisor 1.6.1
- In-Memory Area 1.3.1, 2.1.1, 3.1, 4.3.2
- join groups 6.2
- JSON optimizations 5.1.2.1
- Oracle Data Pump 1.6.4
- Oracle Enterprise Manager Cloud Control A
- Oracle RAC 10, 10.1.2, 10.1.2.1, 10.1.2.1.1, 10.1.2.1.2, 10.1.2.1.3, 10.1.2.2, 10.1.2.2.1, 10.1.2.2.2, 10.1.2.2.3
- overview 10.1
- performance benefits 1.3.2
- population 4.1, 4.1.1, 4.1.2, 4.1.2.2
- population of columnar data 4.1.2.1
- population of data at startup 9.1.2
- prioritization of data population 4.1.2.1, 4.1.3.2, 9.1.2.2
- priority options 4.1.3.2, 9.1.2.2
- repopulation 8.1, 8.2.2
- SIMD vector processing 2.5, 7.2
- storage units 2.2
- trickle repopulation 8.3.1
- VECTOR GROUP BY 7.2, 7.2.2
- vector joins 6.1
- virtual columns 4.3.1, 5.1.2.2
In-Memory Compression Units (IMCUs) 1.3.2.1, 2.2.1, 4.1.2.2, 9.1.2
- Column Compression Units (CUs) 2.2.1.2
- common dictionaries 6.4.1
- double buffering 8.2.1.2
- FastStart area 9.1.2.1
- In-Memory Expression Units (IMEUs) 2.2.3
- mirroring 10.1.2.2, 10.1.2.2.1, 10.1.2.2.2, 10.1.2.2.3
- relationship to IMEUs 5.1.2.5
- row subsets 2.2.1.1.2
- schema objects and 2.2.1.1
- Snapshot Metadata Units (SMUs) 2.2.2.1
- transaction journals 2.2.2.2
In-Memory Coordinator Process (IMCO) 2.4.1, 4.7.3.2, 5.1.2.4, 8.3.1
In-Memory data affinity
- Oracle RAC 10.1.3
In-Memory Expressions
- See: IM expressions
In-Memory Expression Units (IMEUs) 2.2.3, 5.1.2.4, 5.1.2.5
In-Memory FastStart 9.1, 10.1
- See: IM FastStart
- disabling 9.5
- enabling 9.2
- FastStart area 9.1.1, 9.1.2, 9.1.2.1, 9.1.2.2
- managing 9
- migrating tablespace 9.4
- Oracle RAC 10.1.4
- purpose 9.1.1
- retrieving tablespace name 9.3
In-Memory process architecture 2.4
- In-Memory Coordinator Process (IMCO) 2.4.1
- Space Management Worker Processes (Wnnn) 2.4.2
In-Memory virtual columns 4.3.1, 5.1.2.2
- enabling 4.3.2

J

join groups 6.4.3
- benefits 6.3
- common dictionaries 6.4.1
- creating 6.5
- how they work 6.4
- In-Memory Column Store 6.2
- monitoring 6.6
- scan optimization 6.4.2
joins
- Bloom filters 1.3.2.2, 6.1, 7.3.1
- join groups 6.2
- star queries 6.1, 10.1.2.2.2
JSON 5.1.3.1
- IM expressions infrastructure 5.1.2.1

K

key vectors 7.3.2

L

local dictionaries 2.2.1.2, 2.2.1.2.2

M

materialized views
- IM expressions 5.1.1
- In-Memory Column Store 4.5
MEMCOMPRESS clause of CREATE TABLE 4.1.3.3, 4.3.3
metadata pool 2.1.1.2
- Snapshot Metadata Units (SMUs) 2.2.2.1

N

NO DUPLICATE clause of CREATE TABLE 10.1.2.2.3

O

optimizer
- ESS statistics 5.1.2.3
OPTIMIZER_INMEMORY_AWARE initialization parameter 12
Oracle Compression Advisor 3.2, 4.1.3.4
Oracle Database In-Memory
- See: Database In-Memory
Oracle Data Guard 1.3.4
Oracle Data Pump
- In-Memory Column Store 1.6.4
Oracle Engineered Systems 10.1.2.2, 10.1.2.2.1, 10.1.2.2.2
Oracle Enterprise Manager Cloud Control
- In-Memory Column Store A
Oracle RAC
- Auto DOP 10.1.3.2
- deploying IM column stores 10
- distribution and duplication of data 10.1.2
- distribution by rowid 10.1.2.1.3
- distribution of partitions 10.1.2.1, 10.1.2.1.1
- distribution of subpartitions 10.1.2.1.2
- duplication 10.1.2.2, 10.1.2.2.1, 10.1.2.2.2, 10.1.2.2.3
- IM column store 10.1
- IM FastStart 10.1.4
- In-Memory data affinity 10.1.3
- serial queries 10.1.3.1
- services 10.2, 10.2.1, 10.2.2, 10.2.3, 11.2
- shared-nothing architecture 10.1.1
Oracle Real Application Clusters (Oracle RAC) 1.3.4
- See: Oracle RAC

P

PARALLEL_DEGREE_LIMIT initialization parameter 10.1.3.2
PARALLEL_DEGREE_POLICY initialization parameter 10.1.3.1, 10.1.3.2
PARALLEL_INSTANCE_GROUP initialization parameter 10.2.1, 10.2.2, 11.2
PARALLEL_MIN_TIME_THRESHOLD initialization parameter 10.1.3.2
parallel queries 1.6.1, 10.1.3.1, 10.1.3.2
- Oracle RAC 10.1.3
partitioned tables 10.1.2.2.1, 10.1.2.2.2, 10.1.2.2.3
- distributing in Oracle RAC 10.1.2.1, 10.1.2.1.1, 10.1.2.1.2
- repopulating 8.2.3
partition exchange loads 8.2.3
policies, ADO 4.7.1, 4.7.3.2
population, In-Memory
- forcing 4.6
- purpose 4.1.1
primary databases, Active Data Guard 11.1.1, 11.1.1.1, 11.1.1.2, 11.1.1.3
prioritization, of In-Memory population 4.1.2.1, 4.1.3.2, 9.1.2.2
PRIORITY clause of CREATE TABLE 4.1.3.2, 9.1.2.2

Q

queries, analytic 1.1, 1.3, 1.3.2, 1.3.2.1, 1.3.3
query transformations
- In-Memory Aggregation 7

R

repopulation
- controlling 8.4
- data loading 8.2
- definition 8.1
- direct path loads 8.2.2
- double buffering 8.2.1.2, 8.3.2
- factors affecting 8.3.2
- IMEUs 5.1.2.5
- partition exchange load 8.2.3
- staleness threshold 8.2.1.1
- threshold-based 8.2.1.1, 8.2.1.2, 8.3.1
- trickle 8.2.1.2, 8.3.1
- tutorial 8.5
- when it occurs 8.3
REPORT_SQL_MONITOR_XML function 6.6
row format 2.1
rowids
- distributing by in Oracle RAC 10.1.2.1.3

S

SecureFiles LOBs 9.1.2, 9.1.2.1
services, Oracle RAC 10.2, 10.2.1, 10.2.2, 10.2.3, 10.2.4, 11.2
SGA_TARGET initialization parameter 2.1.1.1
SGA (system global area)
- In-Memory Area 1.3.1, 2.1.1, 3.1, 4.3.2
- In-Memory Column Store 2
SIMD vector processing 1.3.2.1, 2.5, 4.3.2, 7.2
SMUs
- See: Snapshot Metadata Units (SMUs)
Snapshot Metadata Units (SMUs) 2.2.2, 8.1, 8.2.1, 8.2.1.1, 8.3.1
- In-Memory Compression Units (IMCUs) 2.2.2.1
- transaction journals 2.2.2.2
Space Management Slave Processes (Wnnn) 10.1.2.1, 10.1.2.1.2
Space Management Worker Processes (Wnnn) 2.4.2, 4.1.2.2, 5.1.2.4, 8.3.1, 8.5, 9.1.2, 9.1.2.1
SRVCTL 10.2.4
standby databases, Active Data Guard 11.1.1, 11.1.1.1, 11.1.1.2, 11.1.1.3
star queries 6.1, 7.3.4.1, 10.1.2.2.2, 10.1.2.2.3
storage mirroring 10.1.2.2
subpartitioned tables 10.1.2.1.2
SYS_IME virtual columns 5.1.2.2, 5.3
SYSAUX tablespace 9.1.2.1

T

TABLE ACCESS IN MEMORY FULL operation 2.1.2
tables
- In-Memory Column Store 4.2.1, 4.2.2
tablespaces
- In-Memory Column Store 4.4
threshold-based repopulation 8.2.1.1, 8.2.1.2, 8.3.1
transaction journals 2.2.2.2, 8.1, 8.2.1, 8.2.1.1, 8.3.1
transformations
- VECTOR GROUP BY 1.3.2.3, 7.2
trickle repopulation 8.3.1, 8.5
- factors affecting repopulation 8.3.2

V

V$HEAT_MAP_SEGMENT view 13
V$IM_COLUMN_LEVEL view 4.3.3, 13
V$IM_SEGMENTS view 4.1.2.1, 8.2.2, 13
- estimating memory 3.2
V$INMEMORY_AREA initialization parameter 2.1.1.2
V$INMEMORY_AREA view 2.1.1.1, 13
V$INMEMORY_FASTSTART_AREA view 9.3, 9.5
V$SESSION view 6.6
V$SGA view 2.1.1.1, 13
VECTOR_TRANSFORM_DIMS hint 7.4
VECTOR_TRANSFORM_FACT hint 7.4
vector aggregation
- See: In-Memory Aggregation
VECTOR GROUP BY aggregation
- IM column store 7.2.2
- scenarios 7.2.1
VECTOR GROUP BY transformations 1.3.2.3
vector joins
- In-Memory Column Store 6.1
vector processing, SIMD 2.5, 4.3.2
virtual columns 4.3.1, 5.1.2.5, 5.3
- hidden 5.1.2.2, 5.1.2.3
- IMEU storage 5.1.2.5
- IM expressions infrastructure 5.1.2.1

W

Wnnn processes
- See: Space Management Worker Processes (Wnnn)