Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  V  W  

---

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, 7.5
• 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, IV
• 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.1.2.4, 6.3
  • 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 IV
  • 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, 7.5
  • 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
  • benefits 7.3
  • common dictionaries 7.4.1, 7.5
  • 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)