Index

A

Active Data Guard
- about 13.1
- configuring IM column store 13.2
- how IM column store works 13.1.2
- purpose 13.1.1, 13.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 6.1.3.1
ALL_JSON_COLUMNS view 7.1.2.1
ALTER MATERIALIZED VIEW statement 4.1.3.1.3, 4.5
ALTER TABLESPACE statement 4.1.3.1.4
ALTER TABLE statement 2.2.1.1, 4.1.3.1.1, 4.1.3.1.2, 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 12.1.3.2
Automatic Data Optimization (ADO) 6.2.1
- Automatic In-Memory 6
- enabling 6.1
- Heat Map 6.1.3.1
- how policies work 6.1.3.2
- In-Memory Column Store 6.1.5
- policies 6.1.1
- purpose 6.1.2
- user interface 6.1.4
Automatic In-Memory
- , setting the time interval 6.2.5
- configuring 6, 6.2
- controlling 6.2.4
- how it works 6.2.2
- purpose 6.2.1

B

Bloom filters 1.3.2.2, 8.1, 9.1.2, 9.1.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 11.1.2.1
- local dictionary 2.2.1.2
- row modifications 10.2.1
common dictionaries 8.4.1, 8.5
COMPATIBLE initialization parameter 3.3, 4.3.1, 4.3.2, 6.1.4
compression 3.2
- effect on repopulation 10.3.2
- Hybrid Columnar Compression 2.2.1.1.2
- In-Memory Column Store 2.2.1.1.2
- methods 4.1.3.3
conventional DML 10.2.1
CPU_COUNT initialization parameter 4.1.2.2
CPU architecture 10.5
- SIMD vector processing 1.3.2.1, 9.1.2
CREATE MATERIALIZED VIEW statement 4.1.3.1.3, 4.5
CREATE TABLE AS SELECT statement 10.2.2
CREATE TABLESPACE statement 4.1.3.1.4
CREATE TABLE statement 4.1.3.1.1, 4.1.3.1.2, 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 12.1.1
Database Resource Manager 2.4.3.1, 2.4.3.2.1
data flow operator (DFO) 9.1.3
data loading, into IM column store 10.2
DBA_EXPRESSION_STATISTICS view 15
DBA_FEATURE_USAGE_STATISTICS view 15
DBA_HEAT_MAP_SEGMENT view 6.1.1, 15
DBA_ILMDATAMOVEMENTPOLICIES view 15
DBA_IM_EXPRESSIONS view 7.1, 15
DBA_INMEMORY_AIMTASKDETAILS 15
DBA_INMEMORY_AIMTASKDETAILS view 6.2.3
DBA_INMEMORY_AIMTASKS 15
DBA_INMEMORY_AIMTASKS view 6.2.3
DBA_JOINGROUPS view 15
DBA_TABLES view 4.1.3.1, 12.1.2.1, 15
DBMS_COMPRESSION PL/SQL package 3.2, 4.1.3.4
DBMS_HEATMAP PL/SQL package 6.1.4
DBMS_ILM_ADMIN PL/SQL package 6.1.4
DBMS_ILM PL/SQL package 6.1.4, 6.1.5
DBMS_INMEMORY_ADMIN package 7.1, 7.1.2.2, 7.1.3.2, 7.1.4, 7.3, 7.4, 11.1.2, 11.4
- AIM_GET_PARAMETER procedure 6.2.5
- AIM_SET_PARAMETER procedure 6.2.3, 6.2.5
- FASTSTART_DISABLE procedure 11.5
- POPULATE_WAIT function 5.1, 5.1.3, 5.2
DBMS_INMEMORY package 7.1, 7.1.3.2, 7.4
- POPULATE procedure 5.1, 5.1.2, 5.2
- REPOPULATE procedure 5.1, 5.1.4, 5.2, 10.3, 10.4
DBMS_SQLTUNE PL/SQL package 8.7
dense keys 9.1.3.2
- dense grouping keys 9.1.3, 9.1.3.2
- dense join keys 9.1.3.2
dictionaries
- common 8.4.1
- local 2.2.1.2.2
direct path loads
- into IM column store 10.2.2
DISTRIBUTE clause of CREATE TABLE 12.1.2, 12.1.2.1, 12.1.2.1.1, 12.1.2.1.2, 12.1.2.1.3
DISTRIBUTE FOR SERVICE subclause of CREATE TABLE 12.2.2, 13.2
DML
- conventional 10.2.1
- direct path loads 10.2.2
- double buffering 10.2.1.2
- staleness threshold 10.2.1.1
double buffering 10.2.1.2, 10.3.2
DUPLICATE clause of CREATE TABLE 12.1.2, 12.1.2.2, 12.1.2.2.1, 12.1.2.2.2, 12.1.4, 12.2.3
duplication, Oracle RAC 12.1.2.2, 12.1.2.2.1, 12.1.2.2.2, 12.1.2.2.3

E

Enterprise Manager Cloud Control (Cloud Control) 1.6.2
Exadata Smart Flash Cache 2.5.3
Exadata Smart Scan 2.5
execution plans
- In-Memory Dynamic Scans 2.4.3.3
expressions, In-Memory 2.2.3, 7, 7.1.3.1
Expression Statistics Store (ESS) 2.2, 2.3, 7.1.2.3
external tables
- INMEMORY subclause 4.1.3.1.2
- populating 4.2.3.3, 5.3.4

F

FASTSTART_DISABLE procedure 11.5
FASTSTART_ENABLE procedure 11.1.2, 11.2
FASTSTART_MIGRATE_STORAGE procedure 11.4
FastStart area 11.1.2.1, 11.1.2.2
- disabling 11.5
- migrating 11.4
FOR SERVICE subclause of CREATE TABLE 12.2.4
FULL hint 5.1.1

G

granules 2.2.1.1.3

H

HEAT_MAP initialization parameter 6.1.4
Heat Map 6, 6.1.2, 6.1.3.1
High Availability 1.3.5
- benefits of the DUPLICATE ALL clause 12.1.2.2.2
- benefits of the NO DUPLICATE clause 12.1.2.2.3
- IM column store 1.3.1.3, IV
hints
- VECTOR_TRANSFORM_DIMS 9.1.4
- VECTOR_TRANSFORM_FACT 9.1.4
Hybrid Columnar Compression 2.2.1.1.2

I

ILM clause of ALTER TABLE 6.1.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)
IM dynamic scans 2.4.3
- See also: In-Memory Dynamic Scans
IME_CAPTURE_EXPRESSIONS procedure 7.1.2.4, 7.1.3.2, 7.3
IME_CLOSE_CAPTURE_WINDOW procedure 7.1.3.2
IME_DROP_ALL_EXPRESSIONS procedure 7.1.2.2, 7.1.3.2, 7.4
IME_DROP_EXPRESSIONS procedure 7.1.2.2, 7.1.3.2, 7.4
IME_GET_CAPTURE_STATE procedure 7.1.3.2
IME_OPEN_CAPTURE_WINDOW procedure 7.1.3.2
IME_POPULATE_EXPRESSIONS procedure 7.1.3.2
IMEUs
- See: In-Memory Expression Units (IMEUs)
IM expressions 7.1, 7.1.2
- administering 7.1.3.2
- basic tasks 7.1.4
- benefits 7.1.1
- capturing 7.1.2.2, 7.3
- configuring 7.2
- dropping 7.4
- Expression Statistics Store (ESS) 2.3, 7.1.2.3
- JSON columns 7.1.3.1
- JSON optimizations 7.1.2.1
- materialized views 7.1.1
- modes of operation 7.1.3.1
- overview 2.2.3, 7
- populating 7.1.2.4, 7.3
- storage in IMEUs 7.1.2.5
- user interfaces 7.1.3
- virtual columns 7.1.2.1
IM FastStart
- See: In-Memory FastStart
IM storage indexes 2.2.1.3
indexes, analytic 1.3.3
INMEMORY_AUTOMATIC_LEVEL initialization parameter 6.2.3, 6.2.4
INMEMORY_CLAUSE_DEFAULT initialization parameter 14
INMEMORY_EXPRESSIONS_USAGE initialization parameter 7.1.2.1, 7.1.2.4, 7.1.3.1, 7.1.4, 7.2, 14
INMEMORY_FORCE initialization parameter 14
INMEMORY_MAX_POPULATE_SERVERS initialization parameter 4.1.2.2, 10.3.1, 10.4, 14
INMEMORY_OPTIMIZED_ARITHMETIC initialization parameter 9.2.2, 14
INMEMORY_QUERY initialization parameter 14
INMEMORY_SIZE initialization parameter 1.3.6, 2.1.1.1, 3.1, 3.3, 3.4, 3.5, 6.1.4, 6.1.5, 7.1.3.1, 7.2, 9.1.1, 12.2.4, 13.1.1.1, 13.1.1.2, 13.1.1.3, 14
INMEMORY_TRICKLE_POPULATE_SERVERS_PERCENT initialization parameter 14
INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT initialization parameter 10.3.1, 10.3.2, 10.4, 10.5
INMEMORY_VIRTUAL_COLUMNS initialization parameter 4.3.1, 4.3.2, 7.1.2.4, 14
In-Memory Advisor 1.6.1
In-Memory Aggregation 1.3.1, 1.3.2.3, 9.1, 9.1.2.2
- about 9.1.1
- controls 9.1.4
- how it works 9.1.3
- phases 9.1.3.3
- purpose 9.1.2
- scenario 9.1.3.4
- when it occurs 9.1.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, 13.1.1.1, 13.1.1.2, 13.1.1.3
INMEMORY clause of CREATE TABLE 4.2.1
INMEMORY clause of CREATE TABLESPACE 4.4
In-Memory column store
- ineligible for population 4.1.3.1
In-Memory Column Store 1
- about 1.1
- Active Data Guard 13.1, 13.1.1, 13.1.1.1, 13.1.1.2, 13.1.1.3, 13.2
- advantages 1.3
- architecture 2.2
- Automatic Data Optimization 6.1.5
- benefits 1.3.6
- columnar format 2
- compression 2.2.1.1.2, 3.2, 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 11.1.2
- High Availability IV
- IM expressions 2.2.3, 7, 7.1, 7.1.1, 7.1.2.2, 7.1.3.1
- IM FastStart 11.1, 11.1.1, 11.2, 11.3, 11.4, 11.5
- IM storage indexes 2.2.1.3
- increasing dynamically 3.4
- initialization parameters 14
- In-Memory Advisor 1.6.1
- In-Memory Area 1.3.1, 2.1.1, 3.1, 4.3.2
- join groups 8.2
- JSON optimizations 7.1.2.1
- Oracle Data Pump 1.6.4
- Oracle Enterprise Manager Cloud Control A
- Oracle RAC 12, 12.1, 12.1.2, 12.1.2.1, 12.1.2.1.1, 12.1.2.1.2, 12.1.2.1.3, 12.1.2.2, 12.1.2.2.1, 12.1.2.2.2, 12.1.2.2.3
- overview 12.1
- performance benefits 1.3.2
- population 4.1, 4.1.1, 4.1.2, 4.1.2.1, 4.1.2.2
- population of data at startup 11.1.2
- population of external tables 4.2.3.3, 5.3.4
- prioritization of data population 4.1.3.2, 11.1.2.2
- prioritization of In-Memory population 4.1.2.1
- priority options 4.1.3.2, 11.1.2.2
- repopulation 10.1, 10.2.2
- SIMD vector processing 2.5, 9.1.2
- storage units 2.2
- trickle repopulation 10.3.1
- VECTOR GROUP BY 9.1.2, 9.1.2.2
- vector joins 8.1
- virtual columns 4.3.1, 7.1.2.2
In-Memory Compression Units (IMCUs) 1.3.2.1, 2.2.1, 4.1.2.2, 11.1.2
- Column Compression Units (CUs) 2.2.1.2
- common dictionaries 8.4.1, 8.5
- double buffering 10.2.1.2
- FastStart area 11.1.2.1
- In-Memory Expression Units (IMEUs) 2.2.3
- mirroring 12.1.2.2, 12.1.2.2.1, 12.1.2.2.2, 12.1.2.2.3
- relationship to IMEUs 7.1.2.5
- row subsets 2.2.1.1.3
- 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, 6.1.3.2, 7.1.2.4, 10.3.1
In-Memory data affinity
- Oracle RAC 12.1.3
In-Memory Dynamic Scans 2.4.3
- execution plans 2.4.3.3
- how they work 2.4.3.2
- lightweight threads 2.4.3.2, 2.4.3.2.1, 2.4.3.2.3
- parallel queries 12.1.3.1
- purpose 2.4.3.1
In-Memory Expressions
- See: IM expressions
In-Memory Expression Units (IMEUs) 2.2.3, 7.1.2.4, 7.1.2.5
In-Memory FastStart 11.1, 12.1
- See: IM FastStart
- disabling 11.5
- enabling 11.2
- FastStart area 11.1.1, 11.1.2, 11.1.2.1, 11.1.2.2
- managing 11
- migrating tablespace 11.4
- Oracle RAC 12.1.4
- purpose 11.1.1
- retrieving tablespace name 11.3
In-Memory Optimized Arithmetic 9.2
- about 9.2.1
- enabling and disabling 9.2.2
- INMEMORY_OPTIMIZED_ARITHMETIC initialization parameter 14
- SIMD vector processing 2.5, 2.5.2
In-Memory process architecture 2.4
- In-Memory Coordinator Process (IMCO) 2.4.1
- Space Management Worker Processes (Wnnn) 2.4.2
INMEMORY subclause 4.1.3.1
In-Memory virtual columns 4.3.1, 7.1.2.2
- enabling 4.3.2

J

join groups 8
- benefits 8.3
- common dictionaries 8.4.1, 8.5
- creating 8.6
- how they work 8.4
- In-Memory Column Store 8.2
- monitoring 8.7
- scan optimization 8.4.2
- single-column 8.2
joins
- Bloom filters 1.3.2.2, 8.1, 9.1.3.1
- join groups 8.2
- star queries 8.1, 12.1.2.2.2
JSON 7.1.3.1
- IM expressions infrastructure 7.1.2.1

K

key vectors 9.1.3.2

L

lightweight threads 2.4.3.2.1
LOBs 2.5, 2.5.1
local dictionaries 2.2.1.2, 2.2.1.2.2

M

materialized views
- IM expressions 7.1.1
- In-Memory Column Store 4.5
- INMEMORY subclause 4.1.3.1.3
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 12.1.2.2.3
NUMBER data type 2.5, 2.5.2, 9.2, 9.2.1, 9.2.2, 14

O

optimizer
- ESS statistics 7.1.2.3
OPTIMIZER_INMEMORY_AWARE initialization parameter 14
Oracle Compression Advisor 3.2, 4.1.3.4
Oracle Database In-Memory
- See: Database In-Memory
Oracle Data Guard 1.3.5
- configure IM column store 13.2
Oracle Data Pump
- In-Memory Column Store 1.6.4
Oracle Engineered Systems 12.1.2.2, 12.1.2.2.1, 12.1.2.2.2
Oracle Enterprise Manager Cloud Control
- In-Memory Column Store A
Oracle RAC
- Auto DOP 12.1.3.2
- deploying IM column stores 12
- distribution and duplication of data 12.1.2
- distribution by rowid 12.1.2.1.3
- distribution of partitions 12.1.2.1, 12.1.2.1.1
- distribution of subpartitions 12.1.2.1.2
- duplication 12.1.2.2, 12.1.2.2.1, 12.1.2.2.2, 12.1.2.2.3
- IM column store 12.1
- IM FastStart 12.1.4
- In-Memory data affinity 12.1.3
- serial queries 12.1.3.1
- services 12.2, 12.2.1, 12.2.2, 12.2.3
- shared-nothing architecture 12.1.1
Oracle Real Application Clusters (Oracle RAC) 1.3.5
- See: Oracle RAC

P

PARALLEL_DEGREE_LIMIT initialization parameter 12.1.3.2
PARALLEL_DEGREE_POLICY initialization parameter 12.1.3.1, 12.1.3.2
PARALLEL_INSTANCE_GROUP initialization parameter 12.2.1, 12.2.2, 13.2
PARALLEL_MIN_TIME_THRESHOLD initialization parameter 12.1.3.2
parallel queries 1.6.1, 12.1.3.1, 12.1.3.2
- Oracle RAC 12.1.3
partitioned tables 12.1.2.2.1, 12.1.2.2.2, 12.1.2.2.3
- distributing in Oracle RAC 12.1.2.1, 12.1.2.1.1, 12.1.2.1.2
- repopulating 10.2.3
partition exchange loads 10.2.3
policies, ADO 6, 6.1.1, 6.1.3.2, 6.2.1
POPULATE_WAIT function 5.1, 5.1.3, 5.2
POPULATE procedure 5.1, 5.1.2, 5.2
population, In-Memory
- about 5.1, 5.1.1, 5.1.2, 5.1.3, 5.1.4, 5.2
- forcing 5.2
- ineligible objects 4.1.3.1
- initiating 5.1, 5.1.1, 5.1.2, 5.1.3, 5.1.4, 5.2
- purpose 4.1.1
primary databases, Active Data Guard 13.1.1, 13.1.1.1, 13.1.1.2, 13.1.1.3, 13.2
prioritization, of In-Memory population 4.1.2.1, 4.1.3.2, 11.1.2.2
PRIORITY clause of CREATE TABLE 4.1.3.2, 11.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 9.1

R

REPOPULATE procedure 5.1, 5.1.4, 5.2
repopulation
- controlling 10.4
- data loading 10.2
- definition 10.1
- direct path loads 10.2.2
- double buffering 10.2.1.2, 10.3.2
- factors affecting 10.3.2
- IMEUs 7.1.2.5
- partition exchange load 10.2.3
- staleness threshold 10.2.1.1
- threshold-based 10.2.1.1, 10.2.1.2, 10.3.1
- trickle 10.2.1.2, 10.3.1
- tutorial 10.5
- when it occurs 10.3
REPORT_SQL_MONITOR_XML function 8.7
row format 2.1
rowids
- distributing by in Oracle RAC 12.1.2.1.3

S

SecureFiles LOBs 11.1.2, 11.1.2.1
services, Oracle RAC 12.2, 12.2.1, 12.2.2, 12.2.3, 12.2.4
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 2.5.3
SIMD vector processing 1.3.2.1, 2.5, 2.5.1, 4.3.2, 9.1.2
SMUs
- See: Snapshot Metadata Units (SMUs)
Snapshot Metadata Units (SMUs) 2.2.2, 10.1, 10.2.1, 10.2.1.1, 10.3.1
- In-Memory Compression Units (IMCUs) 2.2.2.1
- transaction journals 2.2.2.2
Space Management Slave Processes (Wnnn) 12.1.2.1, 12.1.2.1.2
Space Management Worker Processes (Wnnn) 2.4.2, 4.1.2.2, 7.1.2.4, 10.3.1, 10.5, 11.1.2, 11.1.2.1
SRVCTL 12.2.4
standby databases, Active Data Guard 13.1.1, 13.1.1.1, 13.1.1.2, 13.1.1.3, 13.2
star queries 8.1, 9.1.3.4.1, 12.1.2.2.2, 12.1.2.2.3
storage mirroring 12.1.2.2
subpartitioned tables 12.1.2.1.2
SYS_IME virtual columns 7.1.2.2, 7.3
SYSAUX tablespace 11.1.2.1

T

TABLE ACCESS IN MEMORY FULL operation 2.1.2
tables
- external 4.1.3.1.2, 4.2.3.3, 5.3.4
- In-Memory Column Store 4.2.1, 4.2.2
- INMEMORY subclause 4.1.3.1.1
table scan processes 2.4.3.2.1
tablespaces
- In-Memory Column Store 4.4
- INMEMORY subclause 4.1.3.1.4
threshold-based repopulation 10.2.1.1, 10.2.1.2, 10.3.1
transaction journals 2.2.2.2, 10.1, 10.2.1, 10.2.1.1, 10.3.1
transformations
- VECTOR GROUP BY 1.3.2.3, 9.1.2
trickle repopulation 10.3.1, 10.5
- factors affecting repopulation 10.3.2

V

V$HEAT_MAP_SEGMENT view 15
V$IM_ADOTASKDETAILS view 6.2.3
V$IM_ADOTASKS view 6.2.3
V$IM_COLUMN_LEVEL view 4.3.3, 15
V$IM_SEGMENTS view 4.1.2.1, 10.2.2, 15
- estimating memory 3.2
V$INMEMORY_AREA view 2.1.1.1, 2.1.1.2, 15
V$INMEMORY_FASTSTART_AREA view 11.3, 11.5
V$SESSION view 8.7
V$SGA view 2.1.1.1, 15
VECTOR_TRANSFORM_DIMS hint 9.1.4
VECTOR_TRANSFORM_FACT hint 9.1.4
vector aggregation
- See: In-Memory Aggregation
VECTOR GROUP BY aggregation
- IM column store 9.1.2.2
- scenarios 9.1.2.1
VECTOR GROUP BY transformations 1.3.2.3
vector joins
- In-Memory Column Store 8.1
vector processing, SIMD 2.5, 4.3.2
virtual columns 4.3.1, 7.1.2.5, 7.3
- hidden 7.1.2.2, 7.1.2.3
- IMEU storage 7.1.2.5
- IM expressions infrastructure 7.1.2.1

W

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