Index

A

Active Data Guard
- about 12.1
- configuring IM column store 12.2
- how IM column store works 12.1.2
- purpose 12.1.1, 12.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 5.1.3.1
ALL_JSON_COLUMNS view 6.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 11.1.3.2
Automatic Data Optimization (ADO) 5.2.1
- Automatic In-Memory 5
- enabling 5.1
- Heat Map 5.1.3.1
- how policies work 5.1.3.2
- In-Memory Column Store 5.1.5
- policies 5.1.1
- purpose 5.1.2
- user interface 5.1.4
Automatic In-Memory
- , setting the time interval 5.2.5
- configuring 5, 5.2
- controlling 5.2.4
- how it works 5.2.2
- purpose 5.2.1

B

Bloom filters 1.3.2.2, 7.1, 8.1.2, 8.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 10.1.2.1
- local dictionary 2.2.1.2
- row modifications 9.2.1
common dictionaries 7.4.1
COMPATIBLE initialization parameter 3.3, 4.3.1, 4.3.2, 5.1.4
compression 3.2
- effect on repopulation 9.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 9.2.1
CPU_COUNT initialization parameter 4.1.2.2
CPU architecture 9.5
- SIMD vector processing 1.3.2.1, 8.1.2
CREATE MATERIALIZED VIEW statement 4.1.3.1.3, 4.5
CREATE TABLE AS SELECT statement 9.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 11.1.1
Database Resource Manager 2.4.3.1, 2.4.3.2.1
data flow operator (DFO) 8.1.3
data loading, into IM column store 9.2
DBA_EXPRESSION_STATISTICS view 14
DBA_FEATURE_USAGE_STATISTICS view 14
DBA_HEAT_MAP_SEGMENT view 5.1.1, 14
DBA_ILMDATAMOVEMENTPOLICIES view 14
DBA_IM_EXPRESSIONS view 6.1, 14
DBA_INMEMORY_AIMTASKDETAILS view 5.2.3
DBA_INMEMORY_AIMTASKS view 5.2.3
DBA_JOINGROUPS view 14
DBA_TABLES view 4.1.3.1, 11.1.2.1, 14
DBMS_COMPRESSION PL/SQL package 3.2, 4.1.3.4
DBMS_HEATMAP PL/SQL package 5.1.4
DBMS_ILM_ADMIN PL/SQL package 5.1.4
DBMS_ILM PL/SQL package 5.1.4, 5.1.5
DBMS_INMEMORY_ADMIN package 6.1, 6.1.2.2, 6.1.3.2, 6.1.4, 6.3, 6.4, 10.1.2, 10.4
- AIM_GET_PARAMETER procedure 5.2.5
- AIM_SET_PARAMETER procedure 5.2.3, 5.2.5
- FASTSTART_DISABLE procedure 10.5
DBMS_INMEMORY package 6.1, 6.1.3.2, 6.4
- REPOPULATE procedure 9.3, 9.4
DBMS_SQLTUNE PL/SQL package 7.7
dense keys 8.1.3.2
- dense grouping keys 8.1.3, 8.1.3.2
- dense join keys 8.1.3.2
dictionaries
- common 7.4.1
- local 2.2.1.2.2
direct path loads
- into IM column store 9.2.2
DISTRIBUTE clause of CREATE TABLE 11.1.2, 11.1.2.1, 11.1.2.1.1, 11.1.2.1.2, 11.1.2.1.3
DISTRIBUTE FOR SERVICE subclause of CREATE TABLE 11.2.2, 12.2
DML
- conventional 9.2.1
- direct path loads 9.2.2
- double buffering 9.2.1.2
- staleness threshold 9.2.1.1
double buffering 9.2.1.2, 9.3.2
DUPLICATE clause of CREATE TABLE 11.1.2, 11.1.2.2, 11.1.2.2.1, 11.1.2.2.2, 11.1.4, 11.2.3
duplication, Oracle RAC 11.1.2.2, 11.1.2.2.1, 11.1.2.2.2, 11.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, 6, 6.1.3.1
Expression Statistics Store (ESS) 2.2, 2.3, 6.1.2.3
external tables
- INMEMORY subclause 4.1.3.1.2
- populating 4.2.4

F

FASTSTART_DISABLE procedure 10.5
FASTSTART_ENABLE procedure 10.1.2, 10.2
FASTSTART_MIGRATE_STORAGE procedure 10.4
FastStart area 10.1.2.1, 10.1.2.2
- disabling 10.5
- migrating 10.4
FOR SERVICE subclause of CREATE TABLE 11.2.4

G

granules 2.2.1.1.2

H

HEAT_MAP initialization parameter 5.1.4
Heat Map 5, 5.1.2, 5.1.3.1
High Availability 1.3.5
- benefits of the DUPLICATE ALL clause 11.1.2.2.2
- benefits of the NO DUPLICATE clause 11.1.2.2.3
- IM column store 1.3.1.3,
hints
- VECTOR_TRANSFORM_DIMS 8.1.4
- VECTOR_TRANSFORM_FACT 8.1.4
Hybrid Columnar Compression 2.2.1.1.1

I

ILM clause of ALTER TABLE 5.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 6.1.2.4, 6.1.3.2, 6.3
IME_CLOSE_CAPTURE_WINDOW procedure 6.1.3.2
IME_DROP_ALL_EXPRESSIONS procedure 6.1.2.2, 6.1.3.2, 6.4
IME_DROP_EXPRESSIONS procedure 6.1.2.2, 6.1.3.2, 6.4
IME_GET_CAPTURE_STATE procedure 6.1.3.2
IME_OPEN_CAPTURE_WINDOW procedure 6.1.3.2
IME_POPULATE_EXPRESSIONS procedure 6.1.3.2
IMEUs
- See: In-Memory Expression Units (IMEUs)
IM expressions 6.1, 6.1.2
- administering 6.1.3.2
- basic tasks 6.1.4
- benefits 6.1.1
- capturing 6.1.2.2, 6.3
- configuring 6.2
- dropping 6.4
- Expression Statistics Store (ESS) 2.3, 6.1.2.3
- JSON columns 6.1.3.1
- JSON optimizations 6.1.2.1
- materialized views 6.1.1
- modes of operation 6.1.3.1
- overview 2.2.3, 6
- populating 6.3
- population 6.1.2.4
- storage in IMEUs 6.1.2.5
- user interfaces 6.1.3
- virtual columns 6.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 5.2.3, 5.2.4
INMEMORY_CLAUSE_DEFAULT initialization parameter 13
INMEMORY_EXPRESSIONS_USAGE initialization parameter 6.1.2.1, 6.1.2.4, 6.1.3.1, 6.1.4, 6.2, 13
INMEMORY_FORCE initialization parameter 13
INMEMORY_MAX_POPULATE_SERVERS initialization parameter 4.1.2.2, 9.3.1, 9.4, 13
INMEMORY_OPTIMIZED_ARITHMETIC initialization parameter 8.2.2, 13
INMEMORY_QUERY initialization parameter 13
INMEMORY_SIZE initialization parameter 1.3.6, 2.1.1.1, 3.1, 3.3, 3.4, 3.5, 5.1.4, 5.1.5, 6.1.3.1, 6.2, 8.1.1, 11.2.4, 12.1.1.1, 12.1.1.2, 12.1.1.3, 13
INMEMORY_TRICKLE_POPULATE_SERVERS_PERCENT initialization parameter 13
INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT initialization parameter 9.3.1, 9.3.2, 9.4, 9.5
INMEMORY_VIRTUAL_COLUMNS initialization parameter 4.3.1, 4.3.2, 6.1.2.4, 13
In-Memory Advisor 1.6.1
In-Memory Aggregation 1.3.1, 1.3.2.3, 8.1, 8.1.2.2
- about 8.1.1
- controls 8.1.4
- how it works 8.1.3
- phases 8.1.3.3
- purpose 8.1.2
- scenario 8.1.3.4
- when it occurs 8.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, 12.1.1.1, 12.1.1.2, 12.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 12.1, 12.1.1, 12.1.1.1, 12.1.1.2, 12.1.1.3, 12.2
- advantages 1.3
- architecture 2.2
- Automatic Data Optimization 5.1.5
- benefits 1.3.6
- columnar format 2
- compression 2.2.1.1.1, 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 10.1.2
- High Availability
- IM expressions 2.2.3, 6, 6.1, 6.1.1, 6.1.2.2, 6.1.3.1
- IM FastStart 10.1, 10.1.1, 10.2, 10.3, 10.4, 10.5
- IM storage indexes 2.2.1.3
- increasing dynamically 3.4
- initialization parameters 13
- In-Memory Advisor 1.6.1
- In-Memory Area 1.3.1, 2.1.1, 3.1, 4.3.2
- join groups 7.2
- JSON optimizations 6.1.2.1
- Oracle Data Pump 1.6.4
- Oracle Enterprise Manager Cloud Control A
- Oracle RAC 11, 11.1, 11.1.2, 11.1.2.1, 11.1.2.1.1, 11.1.2.1.2, 11.1.2.1.3, 11.1.2.2, 11.1.2.2.1, 11.1.2.2.2, 11.1.2.2.3
- overview 11.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 10.1.2
- population of external tables 4.2.4
- prioritization of data population 4.1.3.2, 10.1.2.2
- prioritization of In-Memory population 4.1.2.1
- priority options 4.1.3.2, 10.1.2.2
- repopulation 9.1, 9.2.2
- SIMD vector processing 2.5, 8.1.2
- storage units 2.2
- trickle repopulation 9.3.1
- VECTOR GROUP BY 8.1.2, 8.1.2.2
- vector joins 7.1
- virtual columns 4.3.1, 6.1.2.2
In-Memory Compression Units (IMCUs) 1.3.2.1, 2.2.1, 4.1.2.2, 10.1.2
- Column Compression Units (CUs) 2.2.1.2
- common dictionaries 7.4.1
- double buffering 9.2.1.2
- FastStart area 10.1.2.1
- In-Memory Expression Units (IMEUs) 2.2.3
- mirroring 11.1.2.2, 11.1.2.2.1, 11.1.2.2.2, 11.1.2.2.3
- relationship to IMEUs 6.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, 5.1.3.2, 6.1.2.4, 9.3.1
In-Memory data affinity
- Oracle RAC 11.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 11.1.3.1
- purpose 2.4.3.1
In-Memory Expressions
- See: IM expressions
In-Memory Expression Units (IMEUs) 2.2.3, 6.1.2.4, 6.1.2.5
In-Memory FastStart 10.1, 11.1
- See: IM FastStart
- disabling 10.5
- enabling 10.2
- FastStart area 10.1.1, 10.1.2, 10.1.2.1, 10.1.2.2
- managing 10
- migrating tablespace 10.4
- Oracle RAC 11.1.4
- purpose 10.1.1
- retrieving tablespace name 10.3
In-Memory Optimized Arithmetic 8.2
- about 8.2.1
- enabling and disabling 8.2.2
- INMEMORY_OPTIMIZED_ARITHMETIC initialization parameter 13
- 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, 6.1.2.2
- enabling 4.3.2

J

join groups 7, 7.5
- benefits 7.3
- common dictionaries 7.4.1
- creating 7.6
- how they work 7.4
- In-Memory Column Store 7.2
- monitoring 7.7
- scan optimization 7.4.2
- single-column 7.2
joins
- Bloom filters 1.3.2.2, 7.1, 8.1.3.1
- join groups 7.2
- star queries 7.1, 11.1.2.2.2
JSON 6.1.3.1
- IM expressions infrastructure 6.1.2.1

K

key vectors 8.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 6.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 11.1.2.2.3
NUMBER data type 2.5, 2.5.2, 8.2, 8.2.1, 8.2.2, 13

O

optimizer
- ESS statistics 6.1.2.3
OPTIMIZER_INMEMORY_AWARE initialization parameter 13
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 12.2
Oracle Data Pump
- In-Memory Column Store 1.6.4
Oracle Engineered Systems 11.1.2.2, 11.1.2.2.1, 11.1.2.2.2
Oracle Enterprise Manager Cloud Control
- In-Memory Column Store A
Oracle RAC
- Auto DOP 11.1.3.2
- deploying IM column stores 11
- distribution and duplication of data 11.1.2
- distribution by rowid 11.1.2.1.3
- distribution of partitions 11.1.2.1, 11.1.2.1.1
- distribution of subpartitions 11.1.2.1.2
- duplication 11.1.2.2, 11.1.2.2.1, 11.1.2.2.2, 11.1.2.2.3
- IM column store 11.1
- IM FastStart 11.1.4
- In-Memory data affinity 11.1.3
- serial queries 11.1.3.1
- services 11.2, 11.2.1, 11.2.2, 11.2.3
- shared-nothing architecture 11.1.1
Oracle Real Application Clusters (Oracle RAC) 1.3.5
- See: Oracle RAC

P

PARALLEL_DEGREE_LIMIT initialization parameter 11.1.3.2
PARALLEL_DEGREE_POLICY initialization parameter 11.1.3.1, 11.1.3.2
PARALLEL_INSTANCE_GROUP initialization parameter 11.2.1, 11.2.2, 12.2
PARALLEL_MIN_TIME_THRESHOLD initialization parameter 11.1.3.2
parallel queries 1.6.1, 11.1.3.1, 11.1.3.2
- Oracle RAC 11.1.3
partitioned tables 11.1.2.2.1, 11.1.2.2.2, 11.1.2.2.3
- distributing in Oracle RAC 11.1.2.1, 11.1.2.1.1, 11.1.2.1.2
- repopulating 9.2.3
partition exchange loads 9.2.3
policies, ADO 5, 5.1.1, 5.1.3.2, 5.2.1
population, In-Memory
- forcing 4.6
- ineligible objects 4.1.3.1
- purpose 4.1.1
primary databases, Active Data Guard 12.1.1, 12.1.1.1, 12.1.1.2, 12.1.1.3, 12.2
prioritization, of In-Memory population 4.1.2.1, 4.1.3.2, 10.1.2.2
PRIORITY clause of CREATE TABLE 4.1.3.2, 10.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 8.1

R

repopulation
- controlling 9.4
- data loading 9.2
- definition 9.1
- direct path loads 9.2.2
- double buffering 9.2.1.2, 9.3.2
- factors affecting 9.3.2
- IMEUs 6.1.2.5
- partition exchange load 9.2.3
- staleness threshold 9.2.1.1
- threshold-based 9.2.1.1, 9.2.1.2, 9.3.1
- trickle 9.2.1.2, 9.3.1
- tutorial 9.5
- when it occurs 9.3
REPORT_SQL_MONITOR_XML function 7.7
row format 2.1
rowids
- distributing by in Oracle RAC 11.1.2.1.3

S

SecureFiles LOBs 10.1.2, 10.1.2.1
services, Oracle RAC 11.2, 11.2.1, 11.2.2, 11.2.3, 11.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, 8.1.2
SMUs
- See: Snapshot Metadata Units (SMUs)
Snapshot Metadata Units (SMUs) 2.2.2, 9.1, 9.2.1, 9.2.1.1, 9.3.1
- In-Memory Compression Units (IMCUs) 2.2.2.1
- transaction journals 2.2.2.2
Space Management Slave Processes (Wnnn) 11.1.2.1, 11.1.2.1.2
Space Management Worker Processes (Wnnn) 2.4.2, 4.1.2.2, 6.1.2.4, 9.3.1, 9.5, 10.1.2, 10.1.2.1
SRVCTL 11.2.4
standby databases, Active Data Guard 12.1.1, 12.1.1.1, 12.1.1.2, 12.1.1.3, 12.2
star queries 7.1, 8.1.3.4.1, 11.1.2.2.2, 11.1.2.2.3
storage mirroring 11.1.2.2
subpartitioned tables 11.1.2.1.2
SYS_IME virtual columns 6.1.2.2, 6.3
SYSAUX tablespace 10.1.2.1

T

TABLE ACCESS IN MEMORY FULL operation 2.1.2
tables
- external 4.1.3.1.2, 4.2.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 9.2.1.1, 9.2.1.2, 9.3.1
transaction journals 2.2.2.2, 9.1, 9.2.1, 9.2.1.1, 9.3.1
transformations
- VECTOR GROUP BY 1.3.2.3, 8.1.2
trickle repopulation 9.3.1, 9.5
- factors affecting repopulation 9.3.2

V

V$HEAT_MAP_SEGMENT view 14
V$IM_ADOTASKDETAILS view 5.2.3
V$IM_ADOTASKS view 5.2.3
V$IM_COLUMN_LEVEL view 4.3.3, 14
V$IM_SEGMENTS view 4.1.2.1, 9.2.2, 14
- estimating memory 3.2
V$INMEMORY_AREA view 2.1.1.1, 2.1.1.2, 14
V$INMEMORY_FASTSTART_AREA view 10.3, 10.5
V$SESSION view 7.7
V$SGA view 2.1.1.1, 14
VECTOR_TRANSFORM_DIMS hint 8.1.4
VECTOR_TRANSFORM_FACT hint 8.1.4
vector aggregation
- See: In-Memory Aggregation
VECTOR GROUP BY aggregation
- IM column store 8.1.2.2
- scenarios 8.1.2.1
VECTOR GROUP BY transformations 1.3.2.3
vector joins
- In-Memory Column Store 7.1
vector processing, SIMD 2.5, 4.3.2
virtual columns 4.3.1, 6.1.2.5, 6.3
- hidden 6.1.2.2, 6.1.2.3
- IMEU storage 6.1.2.5
- IM expressions infrastructure 6.1.2.1

W

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