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 1
    • how IM column store works 1
    • purpose 1, 2
  • Active Session History (ASH) 1
  • advisors
    • In-Memory Advisor 1
    • Oracle Compression Advisor 1, 2
  • ALL_HEAT_MAP_SEGMENT view 1
  • ALL_JSON_COLUMNS view 1
  • ALTER MATERIALIZED VIEW statement 1, 2
  • ALTER TABLESPACE statement 1
  • ALTER TABLE statement 1, 2, 3, 4
  • analytic indexes 1
  • analytic queries 1, 2, 3, 4, 5
  • Auto DOP 1
  • Automatic Data Optimization (ADO)
    • Heat Map 1
    • how policies work 1
    • In-Memory Column Store 1
    • policies 1
    • purpose 1
    • user interface 1

B

  • Bloom filters 1, 2, 3, 4

C

  • columnar data pool 1
  • columnar format 1, 2, 3
    • benefits 1
    • single-format approach 1
  • Column Compression Units (CUs)
    • FastStart area 1
    • local dictionary 1
    • row modifications 1
  • common dictionaries 1
  • COMPATIBLE initialization parameter 1, 2, 3, 4
  • compression 1
    • affect on repopulation 1
    • Hybrid Columnar Compression 1
    • In-Memory Column Store 1
    • methods 1
  • conventional DML 1
  • CPU_COUNT initialization parameter 1
  • CPU architecture 1
    • SIMD vector processing 1, 2
  • CREATE MATERIALIZED VIEW statement 1, 2
  • CREATE TABLE AS SELECT statement 1
  • CREATE TABLESPACE statement 1
  • CREATE TABLE statement 1, 2
  • CUs
    • See: Column Compression Units (CUs)

D

  • database buffer cache 1
  • Database In-Memory 1
    • about 1
    • introduction 1
    • principal tasks 1
    • tools for 1
  • database instances
    • multiple IM column stores 1
  • data flow operator (DFO) 1
  • data loading, into IM column store 1
  • DBA_EXPRESSION_STATISTICS view 1
  • DBA_FEATURE_USAGE_STATISTICS view 1
  • DBA_HEAT_MAP_SEGMENT view 1, 2
  • DBA_ILMDATAMOVEMENTPOLICIES view 1
  • DBA_IM_EXPRESSIONS view 1, 2
  • DBA_JOINGROUPS view 1
  • DBA_TABLES view 1, 2, 3
  • DBMS_COMPRESSION PL/SQL package 1, 2
  • DBMS_HEATMAP PL/SQL package 1
  • DBMS_ILM_ADMIN PL/SQL package 1
  • DBMS_ILM PL/SQL package 1, 2
  • DBMS_INMEMORY_ADMIN package 1, 2, 3, 4, 5, 6, 7, 8
    • FASTSTART_DISABLE procedure 1
  • DBMS_INMEMORY package 1, 2, 3
    • REPOPULATE procedure 1
  • DBMS_INMEMORY procedure
    • REPOPULATE procedure 1
  • DBMS_SQLTUNE PL/SQL package 1
  • dense keys 1
    • dense grouping keys 1, 2
    • dense join keys 1
  • dictionaries
    • common 1
    • local 1
  • direct path loads
    • into IM column store 1
  • DISTRIBUTE clause of CREATE TABLE 1, 2, 3, 4, 5
  • DISTRIBUTE FOR SERVICE subclause of CREATE TABLE 1, 2
  • DML
    • conventional 1
    • direct path loads 1
    • double buffering 1
    • staleness threshold 1
  • double buffering 1, 2
  • DUPLICATE clause of CREATE TABLE 1, 2, 3, 4, 5, 6
  • duplication, Oracle RAC 1, 2, 3, 4

E

  • Enterprise Manager Cloud Control (Cloud Control) 1
  • expressions, In-Memory 1, 2, 3
  • Expression Statistics Store (ESS) 1, 2, 3

F

  • FASTSTART_DISABLE procedure 1
  • FASTSTART_ENABLE procedure 1, 2
  • FASTSTART_MIGRATE_STORAGE procedure 1
  • FastStart area 1, 2
    • disabling 1
    • migrating 1
  • FOR SERVICE subclause of CREATE TABLE 1

G

  • granules 1

H

  • HEAT_MAP initialization parameter 1
  • Heat Map 1, 2
  • High Availability 1
    • benefits of the DUPLICATE ALL clause 1
    • benefits of the NO DUPLICATE clause 1
    • IM column store 1
  • hints
    • VECTOR_TRANSFORM_DIMS 1
    • VECTOR_TRANSFORM_FACT 1
  • Hybrid Columnar Compression 1

I

  • ILM clause of ALTER TABLE 1
  • 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 1, 2, 3
  • IME_DROP_ALL_EXPRESSIONS procedure 1, 2, 3
  • IME_DROP_EXPRESSIONS procedure 1, 2, 3
  • IME_POPULATE_EXPRESSIONS procedure 1
  • IMEUs
    • See: In-Memory Expression Units (IMEUs)
  • IM expressions 1, 2
    • administering 1
    • basic tasks 1
    • benefits 1
    • capturing 1, 2
    • configuring 1
    • dropping 1
    • Expression Statistics Store (ESS) 1, 2
    • JSON columns 1
    • JSON optimizations 1
    • materialized views 1
    • modes of operation 1
    • overview 1, 2
    • populating 1
    • population 1
    • storage in IMEUs 1
    • user interfaces 1
    • virtual columns 1
  • IM FastStart
    • See: In-Memory FastStart
  • IM storage indexes 1
  • indexes, analytic 1
  • INMEMORY_CLAUSE_DEFAULT initialization parameter 1
  • INMEMORY_EXPRESSIONS_USAGE initialization parameter 1, 2, 3, 4, 5, 6
  • INMEMORY_FORCE initialization parameter 1
  • INMEMORY_MAX_POPULATE_SERVERS initialization parameter 1, 2, 3, 4
  • INMEMORY_QUERY initialization parameter 1
  • INMEMORY_SIZE initialization parameter 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16
  • INMEMORY_TRICKLE_POPULATE_SERVERS_PERCENT initialization parameter 1
  • INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT initialization parameter 1, 2, 3, 4
  • INMEMORY_VIRTUAL_COLUMNS initialization parameter 1, 2, 3, 4
  • In-Memory Advisor 1
  • In-Memory Aggregation 1, 2, 3, 4
    • about 1
    • controls 1
    • how it works 1
    • phases 1
    • purpose 1
    • scenario 1
    • when it occurs 1
  • In-Memory Area
    • columnar data pool 1
    • estimating size 1
    • metadata pool 1
    • setting size 1
    • size 1
    • Snapshot Metadata Units (SMUs) 1
  • INMEMORY clause of ALTER TABLE 1, 2, 3, 4
  • INMEMORY clause of CREATE TABLE 1
  • INMEMORY clause of CREATE TABLESPACE 1
  • In-Memory Column Store 1
    • about 1
    • Active Data Guard 1, 2, 3, 4, 5
    • advantages 1
    • and Oracle RAC 1
    • architecture 1
    • Automatic Data Optimization 1
    • benefits 1
    • columnar format 1
    • compression 1, 2
    • compression units 1, 2
    • consistency with buffer cache 1
    • disabling 1
    • disabling tables 1
    • dual memory formats 1, 2
    • enabling existing tables 1
    • enabling for a database 1
    • enabling for materialized views 1
    • enabling for tablespaces 1
    • enabling new tables 1
    • estimating size 1
    • FastStart tablespace 1
    • High Availability 1
    • IM expressions 1, 2, 3, 4, 5, 6
    • IM FastStart 1, 2, 3, 4, 5
      • about 1
    • IM storage indexes 1
    • increasing dynamically 1
    • initialization parameters 1
    • In-Memory Advisor 1
    • In-Memory Area 1, 2, 3, 4
    • join groups 1
    • JSON optimizations 1
    • Oracle Data Pump 1
    • Oracle Enterprise Manager Cloud Control 1
    • Oracle RAC 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
    • overview 1
    • performance benefits 1
    • population 1, 2, 3, 4
    • population of columnar data 1
    • population of data at startup 1
    • prioritization of data population 1, 2, 3
    • priority options 1, 2
    • repopulation 1, 2
    • SIMD vector processing 1, 2
    • storage units 1
    • trickle repopulation 1
    • VECTOR GROUP BY 1, 2
    • vector joins 1
    • virtual columns 1, 2
  • In-Memory Compression Units (IMCUs) 1, 2, 3, 4
    • Column Compression Units (CUs) 1
    • common dictionaries 1
    • double buffering 1
    • FastStart area 1
    • In-Memory Expression Units (IMEUs) 1
    • mirroring 1, 2, 3, 4
    • relationship to IMEUs 1
    • row subsets 1
    • schema objects and 1
    • Snapshot Metadata Units (SMUs) 1
    • transaction journals 1
  • In-Memory Coordinator Process (IMCO) 1, 2, 3, 4
  • In-Memory data affinity
    • Oracle RAC 1
  • In-Memory Expressions
    • See: IM expressions
  • In-Memory Expression Units (IMEUs) 1, 2, 3
  • In-Memory FastStart 1, 2
    • See: IM FastStart
    • disabling 1
    • enabling 1
    • FastStart area 1, 2, 3, 4
    • managing 1
    • migrating tablespace 1
    • Oracle RAC 1
    • purpose 1
    • retrieving tablespace name 1
  • In-Memory process architecture 1
    • In-Memory Coordinator Process (IMCO) 1
    • Space Management Worker Processes (Wnnn) 1
  • In-Memory virtual columns 1, 2
    • enabling 1

J

  • join groups
    • benefits 1
    • common dictionaries 1
    • creating 1
    • how they work 1
    • In-Memory Column Store 1
    • monitoring 1
    • scan optimization 1
  • joins
    • Bloom filters 1, 2, 3
    • join groups 1
    • star queries 1, 2
  • JSON 1
    • IM expressions infrastructure 1

K

  • key vectors 1

L

  • local dictionaries 1, 2

M

  • materialized views
    • IM expressions 1
    • In-Memory Column Store 1
  • MEMCOMPRESS clause of CREATE TABLE 1, 2
  • metadata pool 1
    • Snapshot Metadata Units (SMUs) 1

N

  • NO DUPLICATE clause of CREATE TABLE 1

O

  • optimizer
    • ESS statistics 1
  • OPTIMIZER_INMEMORY_AWARE initialization parameter 1
  • Oracle Compression Advisor 1, 2
  • Oracle Database In-Memory
    • See: Database In-Memory
  • Oracle Data Guard 1
  • Oracle Data Pump
    • In-Memory Column Store 1
  • Oracle Engineered Systems 1, 2, 3
  • Oracle Enterprise Manager Cloud Control
    • In-Memory Column Store 1
  • Oracle RAC
    • Auto DOP 1
    • deploying IM column stores 1
    • distribution and duplication of data 1
    • distribution by rowid 1
    • distribution of partitions 1, 2
    • distribution of subpartitions 1
    • duplication 1, 2, 3, 4
    • IM column store 1
    • IM FastStart 1
    • In-Memory data affinity 1
    • serial queries 1
    • services 1, 2, 3, 4, 5
    • shared-nothing architecture 1
  • Oracle Real Application Clusters (Oracle RAC) 1
    • See: Oracle RAC

P

  • PARALLEL_DEGREE_LIMIT initialization parameter 1
  • PARALLEL_DEGREE_POLICY initialization parameter 1, 2
  • PARALLEL_INSTANCE_GROUP initialization parameter 1, 2, 3
  • PARALLEL_MIN_TIME_THRESHOLD initialization parameter 1
  • parallel queries 1, 2, 3
    • Oracle RAC 1
  • partitioned tables 1, 2, 3
    • distributing in Oracle RAC 1, 2, 3
    • repopulating 1
  • partition exchange loads 1
  • policies, ADO 1, 2
  • population, In-Memory
    • forcing 1
    • purpose 1
  • primary databases, Active Data Guard 1, 2, 3, 4
  • prioritization, of In-Memory population 1, 2, 3
  • PRIORITY clause of CREATE TABLE 1, 2

Q

  • queries, analytic 1, 2, 3, 4, 5
  • query transformations
    • In-Memory Aggregation 1

R

  • repopulation
    • controlling 1
    • data loading 1
    • definition 1
    • direct path loads 1
    • double buffering 1, 2
    • factors affecting 1
    • IMEUs 1
    • partition exchange load 1
    • staleness threshold 1
    • threshold-based 1, 2, 3
    • trickle 1, 2
    • tutorial 1
    • when it occurs 1
  • REPORT_SQL_MONITOR_XML function 1
  • row format 1
  • rowids
    • distributing by in Oracle RAC 1

S

  • SecureFiles LOBs 1, 2
  • services, Oracle RAC 1, 2, 3, 4, 5, 6
  • SGA_TARGET initialization parameter 1
  • SGA (system global area)
    • In-Memory Area 1, 2, 3, 4
    • In-Memory Column Store 1
  • SIMD vector processing 1, 2, 3, 4
  • SMUs
    • See: Snapshot Metadata Units (SMUs)
  • Snapshot Metadata Units (SMUs) 1, 2, 3, 4, 5
    • In-Memory Compression Units (IMCUs) 1
    • transaction journals 1
  • Space Management Slave Processes (Wnnn) 1, 3
  • Space Management Worker Processes (Wnnn) 1, 2, 3, 4, 5, 6, 7
  • SRVCTL 1
  • standby databases, Active Data Guard 1, 2, 3, 4
  • star queries 1, 2, 3, 4
  • storage mirroring 1
  • subpartitioned tables 1
  • SYS_IME virtual columns 1, 2
  • SYSAUX tablespace 1

T

  • TABLE ACCESS IN MEMORY FULL operation 1
  • tables
    • In-Memory Column Store 1, 2
  • tablespaces
    • In-Memory Column Store 1
  • threshold-based repopulation 1, 2, 3
  • transaction journals 1, 2, 3, 4, 5
  • transformations
    • VECTOR GROUP BY 1, 2
  • trickle repopulation 1, 2
    • factors affecting repopulation 1

V

  • V$HEAT_MAP_SEGMENT view 1
  • V$IM_COLUMN_LEVEL view 1, 2
  • V$IM_SEGMENTS view 1, 2, 3
    • estimating memory 1
  • V$INMEMORY_AREA initialization parameter 1
  • V$INMEMORY_AREA view 1, 2
  • V$INMEMORY_FASTSTART_AREA view 1, 2
  • V$SESSION view 1
  • V$SGA view 1, 2
  • VECTOR_TRANSFORM_DIMS hint 1
  • VECTOR_TRANSFORM_FACT hint 1
  • vector aggregation
    • See: In-Memory Aggregation
  • VECTOR GROUP BY aggregation
    • IM column store 1
    • scenarios 1
  • VECTOR GROUP BY transformations 1
  • vector joins
    • In-Memory Column Store 1
  • vector processing, SIMD 1, 2
  • virtual columns 1, 2, 3
    • hidden 1, 2
    • IMEU storage 1
    • IM expressions infrastructure 1

W

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