Table of Contents
- Title and Copyright Information
- Preface
-
Part I Oracle Database In-Memory Concepts
-
1
Introduction to Oracle Database In-Memory
- Challenges for Analytic Applications
- The Single-Format Approach
- The Oracle Database In-Memory Solution
- Requirements for Database In-Memory
- Principal Tasks for Database In-Memory
- Tools for the IM Column Store
- 2 In-Memory Column Store Architecture
-
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
Automating Management of In-Memory Objects
- Configuring Automatic In-Memory
- Enabling ADO for the IM Column Store
- Allowing AIM to Automatically Enable and Manage Performance Features
-
5
Enabling Objects for In-Memory Population Manually
- About Manually Enabling Objects for In-Memory Population
-
Enabling and Disabling Tables for the IM Column Store
- Enabling New Tables for the In-Memory Column Store
- Enabling and Disabling Existing Tables for the IM Column Store
-
Enabling and Disabling Tables for the IM
Column Store
- Creating an In-Memory Table: Example
- Creating a Table with In-Memory Partitions: Example
- Creating an In-Memory External Table: Example
- Creating an In-Memory Partitioned External Table: Example
- Creating and Populating a Hybrid External Table: Example
- Enabling an Existing Table for the IM Column Store: Example
- Setting In-Memory Compression to FOR CAPACITY LOW: Example
- Setting In-Memory Priority to HIGH: Example
- Changing the Compression and Priority Settings for an In-Memory Table: Example
- Disabling a Table for the IM Column Store: Example
- Disabling Columnar Format on Exadata Smart Flash Cache: Example
- Enabling and Disabling Columns for In-Memory Tables
- Enabling and Disabling Tablespaces for the IM Column Store
- Enabling and Disabling Materialized Views for the IM Column Store
-
6
Populating the IM Column Store Manually
- About Manual Population of In-Memory Objects
- Forcing Initial Population of an In-Memory Object
-
Populating In-Memory Tables Manually: Examples
- Populating an In-Memory Table Using a Full Table Scan: Example
- Populating a Table Using the POPULATE Procedure: Example
- Setting a Timeout Using the POPULATE_WAIT Function: Example
- Populating an In-Memory External Table Using DBMS_INMEMORY.POPULATE: Example
- Refreshing an In-Memory External Table Using the REPOPULATE Procedure: Example
-
Part III Optimizing In-Memory Queries
- 7 Optimizing Queries with In-Memory Expressions
-
8
Optimizing In-Memory Joins
- About In-Memory Joins
- Optimizing Joins with Join Groups
- Optimizing Joins Using In-Memory Deep Vectorization
-
9
Optimizing Aggregation
-
Optimizing In-Memory Aggregation with VECTOR GROUP BY
- About IM Aggregation
- Purpose of IM Aggregation
-
How IM Aggregation Works
- When the Optimizer Chooses IM Aggregation
- Key Vector
- Two Phases of IM Aggregation
-
IM Aggregation: Scenario
- Sample Analytic Query of a Star Schema
- Step 1: Key Vector and Temporary Table Creation for geography Dimension
- Step 2: Key Vector and Temporary Table Creation for products Dimension
- Step 3: Key Vector Query Transformation
- Step 4: Row Filtering from Fact Table
- Step 5: Aggregation Using an Array
- Step 6: Join Back to Temporary Tables
- Controls for IM Aggregation
- In-Memory Aggregation: Example
- Optimizing In-Memory Arithmetic
-
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
- 13 Deploying an IM Column Store with Oracle Active Data Guard
- Part V Database In-Memory Reference
-
A
Using IM Column Store in Cloud Control
- Meeting Prerequisites for Using IM Column Store in Cloud Control
- Using the In-Memory Column Store Central Home Page to Monitor In-Memory Support for Database Objects
- Specifying In-Memory Details When Creating a Table or Partition
- Viewing or Editing IM Column Store Details of a Table
- Viewing or Editing IM Column Store Details of a Partition
- Specifying IM Column Store Details During Tablespace Creation
- Viewing and Editing IM Column Store Details of a Tablespace
- Specifying IM Column Store Details During Materialized View Creation
- Viewing or Editing IM Column Store Details of a Materialized View
- Glossary
- Index