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 11.1
  • configuring IM column store 11.2
  • 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, 6.4.3
• COMPATIBLE initialization parameter 3.3, 4.3.1, 4.3.2, 4.7.4
• compression 3.2
  • effect 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.3, 8.4
• DBMS_SQLTUNE PL/SQL package 6.6
• dense keys 7.3.2
  • dense grouping keys 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 IV
• 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.1.2.4, 5.3
  • 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
  • how it works 7.3
• In-Memory Aggregation 1.3.1, 1.3.2.3, 7, 7.2.2
  • about 7.1
  • controls 7.4
  • 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, 11.2
  • advantages 1.3
  • 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 IV
  • IM expressions 2.2.3, 5, 5.1, 5.1.1, 5.1.2.2, 5.1.3.1
  • IM FastStart 9.1, 9.1.1, 9.2, 9.3, 9.4, 9.5
  • 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, 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.1, 4.1.2.2
  • population of data at startup 9.1.2
  • prioritization of data population 4.1.3.2, 9.1.2.2
  • prioritization of In-Memory population 4.1.2.1
  • 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, 6.4.3
  • 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
  • benefits 6.3
  • common dictionaries 6.4.1, 6.4.3
  • 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
  • configure IM column store 11.2
• 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
  • 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, 11.2
• 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
• 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, 11.2
• 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 view 2.1.1.1, 2.1.1.2, 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)