Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database In-Memory Guide
-
Part I Oracle Database In-Memory Concepts
-
1
Introduction to Oracle Database In-Memory
- 1.1 Challenges for Analytic Applications
- 1.2 The Single-Format Approach
- 1.3 The Oracle Database In-Memory Solution
- 1.4 Requirements for Database In-Memory
- 1.5 Principal Tasks for Database In-Memory
- 1.6 Tools for the IM Column Store
-
2
In-Memory Column Store Architecture
- 2.1 Dual-Format: Column and Row
- 2.2 In-Memory Storage Units
- 2.3 Expression Statistics Store (ESS)
- 2.4 In-Memory Process Architecture
- 2.5 CPU Architecture: SIMD Vector Processing
-
1
Introduction to Oracle Database In-Memory
-
Part II Configuring and Populating the IM Column Store
- 3 Enabling and Sizing the IM Column Store
-
4
Enabling Objects for In-Memory Population
-
4.1
About Manually Enabling Objects for In-Memory Population
- 4.1.1 Purpose of Enabling Objects for In-Memory Population
- 4.1.2 How In-Memory Population Works
- 4.1.3 Controls for In-Memory Objects
-
4.2
Enabling and Disabling Tables for the IM Column Store
- 4.2.1 Enabling New Tables for the In-Memory Column Store
- 4.2.2 Enabling and Disabling Existing Tables for the IM Column Store
-
4.2.3
Enabling and Disabling Tables for the IM Column Store: Examples
- 4.2.3.1 Creating an In-Memory Table: Example
- 4.2.3.2 Creating a Table with In-Memory Partitions: Example
- 4.2.3.3 Creating an In-Memory External Table: Example
- 4.2.3.4 Creating and Populating a Hybrid External Table: Example
- 4.2.3.5 Enabling an Existing Table for the IM Column Store: Example
- 4.2.3.6 Setting In-Memory Compression to FOR CAPACITY LOW: Example
- 4.2.3.7 Setting In-Memory Priority to HIGH: Example
- 4.2.3.8 Changing the Compression and Priority Settings for an In-Memory Table: Example
- 4.2.3.9 Disabling a Table for the IM Column Store: Example
- 4.2.3.10 Disabling Columnar Format on Exadata Smart Flash Cache: Example
- 4.3 Enabling and Disabling Columns for In-Memory Tables
- 4.4 Enabling and Disabling Tablespaces for the IM Column Store
- 4.5 Enabling and Disabling Materialized Views for the IM Column Store
-
4.1
About Manually Enabling Objects for In-Memory Population
-
5
Populating the IM Column Store Manually
- 5.1 About Manual Population of In-Memory Objects
- 5.2 Forcing Initial Population of an In-Memory Object
-
5.3
Populating In-Memory Tables Manually: Examples
- 5.3.1 Populating an In-Memory Table Using a Full Table Scan: Example
- 5.3.2 Populating a Table Using the POPULATE Procedure: Example
- 5.3.3 Setting a Timeout Using the POPULATE_WAIT Function: Example
- 5.3.4 Populating an In-Memory External Table Using DBMS_INMEMORY.POPULATE: Example
- 5.3.5 Refreshing an In-Memory External Table Using the REPOPULATE Procedure: Example
- 6 Automating Management of In-Memory Objects
-
Part III Optimizing In-Memory Queries
- 7 Optimizing Queries with In-Memory Expressions
- 8 Optimizing Joins with Join Groups
-
9
Optimizing Aggregation
-
9.1
Optimizing In-Memory Aggregation with VECTOR GROUP BY
- 9.1.1 About IM Aggregation
- 9.1.2 Purpose of IM Aggregation
-
9.1.3
How IM Aggregation Works
- 9.1.3.1 When the Optimizer Chooses IM Aggregation
- 9.1.3.2 Key Vector
- 9.1.3.3 Two Phases of IM Aggregation
-
9.1.3.4
IM Aggregation: Scenario
- 9.1.3.4.1 Sample Analytic Query of a Star Schema
- 9.1.3.4.2 Step 1: Key Vector and Temporary Table Creation for geography Dimension
- 9.1.3.4.3 Step 2: Key Vector and Temporary Table Creation for products Dimension
- 9.1.3.4.4 Step 3: Key Vector Query Transformation
- 9.1.3.4.5 Step 4: Row Filtering from Fact Table
- 9.1.3.4.6 Step 5: Aggregation Using an Array
- 9.1.3.4.7 Step 6: Join Back to Temporary Tables
- 9.1.4 Controls for IM Aggregation
- 9.1.5 In-Memory Aggregation: Example
- 9.2 Optimizing In-Memory Arithmetic
-
9.1
Optimizing In-Memory Aggregation with VECTOR GROUP BY
- 10 Optimizing Repopulation of the IM Column Store
-
Part IV High Availability and the IM Column Store
- 11 Managing IM FastStart for the IM Column Store
-
12
Deploying IM Column Stores in Oracle RAC
- 12.1 Overview of Database In-Memory and Oracle RAC
- 12.2 Configuring In-Memory Services in Oracle RAC
-
13
Deploying an IM Column Store with Oracle Active Data Guard
- 13.1 About Database In-Memory and Active Data Guard
- 13.2 Configuring IM Column Stores in an Oracle Active Data Guard Environment
- Part V Database In-Memory Reference
-
A
Using IM Column Store in Cloud Control
- A.1 Meeting Prerequisites for Using IM Column Store in Cloud Control
- A.2 Using the In-Memory Column Store Central Home Page to Monitor In-Memory Support for Database Objects
- A.3 Specifying In-Memory Details When Creating a Table or Partition
- A.4 Viewing or Editing IM Column Store Details of a Table
- A.5 Viewing or Editing IM Column Store Details of a Partition
- A.6 Specifying IM Column Store Details During Tablespace Creation
- A.7 Viewing and Editing IM Column Store Details of a Tablespace
- A.8 Specifying IM Column Store Details During Materialized View Creation
- A.9 Viewing or Editing IM Column Store Details of a Materialized View
- Glossary
- Index