Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility
• Technical support

What's New

• New features on Release 11.2.1.4.0
• New features in Release 11.2.1.1.0

1 Oracle In-Memory Database Cache Concepts

• Overview of a cache grid
• Overview of cache groups
  • Cache instance
  • Cache group types
  • Transmitting updates between the TimesTen and Oracle databases
  • Loading data into a cache group: Explicitly loaded and dynamic cache groups
  • Sharing data across a cache grid: Local and global cache groups
  • Summary of cache group types
• High availability caching solution

2 Getting Started

• Setting up the Oracle and TimesTen systems
  • Create users in the Oracle database
  • Create a DSN for the TimesTen database
  • Create users in the TimesTen database
  • Set the cache administration user name and password in the TimesTen database
• Creating a cache grid
• Creating cache groups
  • Create the Oracle tables to be cached
  • Start the cache agent
  • Create the cache groups
  • Start the replication agent for the AWT cache group
• Attaching the TimesTen database to the cache grid
• Performing operations on the read-only cache group
  • Manually load the cache group
  • Update the cached Oracle table
• Performing operations on the dynamic updatable global cache group
  • Dynamically load the cache group
  • Update the TimesTen cache table
• Cleaning up the TimesTen and Oracle systems
  • Detach the TimesTen database from the cache grid
  • Stop the replication agent
  • Drop the cache groups
  • Destroy the cache grid
  • Stop the cache agent and destroy the TimesTen database
  • Drop the Oracle users and their objects
• Procedure for caching Oracle data in TimesTen

3 Setting Up a Caching Infrastructure

• Configuring your system to cache Oracle data in TimesTen
  • Oracle In-Memory Database Cache environment variables for UNIX
  • Oracle In-Memory Database Cache environment variables for Microsoft Windows
• Configuring the Oracle database to cache data in TimesTen
  • Create the Oracle users
  • Grant privileges to the Oracle users
  • Automatically create Oracle objects used to manage caching of Oracle data
  • Manually create Oracle objects used to manage caching of Oracle data
• Configuring a TimesTen database to cache Oracle data
  • Define a DSN for the TimesTen database
  • Create the TimesTen users
  • Grant privileges to the TimesTen users
  • Set the cache administration user name and password
• Configuring a cache grid
  • Create a cache grid
  • Associate a TimesTen database with a cache grid
• Testing the connectivity between the TimesTen and Oracle databases
• Managing the cache agent
  • Set a cache agent start policy

4 Defining Cache Groups

• Cache groups and cache tables
  • Single-table cache group
  • Multiple-table cache group
• Creating a cache group
  • Read-only cache group
    • Restrictions with read-only cache groups
  • Asynchronous writethrough (AWT) cache group
    • Managing the replication agent
    • What an AWT cache group does and does not guarantee
    • Restrictions with AWT cache groups
  • Synchronous writethrough (SWT) cache group
    • Restrictions with SWT cache groups
  • User managed cache group
    • PROPAGATE cache table attribute
    • READONLY cache table attribute
  • AUTOREFRESH cache group attribute
    • Altering a cache group
    • Manually creating Oracle objects for automatic refresh cache groups
  • Using a WHERE clause
    • Proper placement of WHERE clause in a CREATE CACHE GROUP statement
    • Referencing Oracle PL/SQL functions in a WHERE clause
  • ON DELETE CASCADE cache table attribute
  • UNIQUE HASH ON cache table attribute
• Caching Oracle synonyms
• Implementing aging on a cache group
  • LRU aging
  • Time-based aging
  • Manually scheduling an aging process
  • Configuring a sliding window
• Dynamic cache groups
• Global cache groups
  • Start the replication agent
  • Attach a TimesTen database to a cache grid

5 Cache Group Operations

• Transmitting updates between the TimesTen and Oracle databases
• Loading and refreshing a cache group
  • Loading and refreshing an explicitly loaded cache group with automatic refresh
  • Loading and refreshing a dynamic cache group with automatic refresh
  • Loading and refreshing a cache group using a WITH ID clause
  • Initiating an immediate automatic refresh
  • Loading and refreshing a multiple-table cache group
  • Improving the performance of loading or refreshing a large number of cache instances
  • Example of manually loading and refreshing an explicitly loaded cache group
  • Example of manually loading and refreshing a dynamic cache group
• Dynamically loading a cache group
  • Types of SQL statements for which dynamic load is available
  • Example of dynamically loading a cache group
  • Disabling dynamic loading
  • Displaying dynamic load errors
• Flushing a user managed cache group
• Unloading a cache group
• Determining the number of cache instances affected by an operation
• Setting a passthrough level
  • Changing the passthrough level for a connection or transaction
  • Determining the passthrough setting for a statement
• Cache performance
  • Dynamic load performance
  • Improving AWT throughput for mixed transactions and network latency

6 Creating Other Cache Grid Members

• Creating and configuring a subsequent standalone TimesTen database
• Replicating cache tables
  • Create and configure the active master database
  • Create and configure the standby master database
  • Create and configure the read-only subscriber database
• Example of data sharing among the grid members
• Adding other elements to a cache grid or grid member

7 Managing a Caching Environment

• Checking the status of the cache and replication agents
• Monitoring cache groups and cache grids
  • Using the ttIsql utility's cachegroups command
  • Monitoring automatic refresh operations on cache groups
  • Monitoring AWT cache group operations
  • Configuring a transaction log file threshold for AWT cache groups
  • Obtaining information about cache grids
  • Suspending global AWT cache group operations
  • Tracking DDL statements issued on cached Oracle tables
• Oracle objects used to manage a caching environment
• Impact of failed automatic refresh operations on TimesTen databases
• Dropping Oracle objects used by automatic refresh cache groups
• Monitoring the cache administration user's tablespace

8 Cleaning up the Caching Environment

• Detaching a TimesTen database from a cache grid
• Stopping the replication agent
• Dropping a cache group
• Destroying a cache grid
• Stopping the cache agent
• Destroying the TimesTen databases
• Dropping the Oracle users and objects

9 Using Oracle In-Memory Database Cache in a RAC Environment

• How Oracle In-Memory Database Cache works in a RAC environment
• Restrictions on using IMDB Cache in a RAC environment
• Setting up IMDB Cache in a RAC environment

10 Using Oracle In-Memory Database Cache with Data Guard

• Components of MAA for Oracle In-Memory Database Cache
• How Oracle In-Memory Database Cache works with Data Guard
  • Configuring the Oracle databases
  • Configuring the TimesTen database

11 Compatibility Between TimesTen and Oracle

• Summary of compatibility issues
• Transaction semantics
• API compatibility
• SQL compatibility
  • Schema objects
  • Differences between Oracle and TimesTen tables
  • Data type support
  • SQL operators
  • SQL functions
  • SQL expressions
  • SQL subqueries
  • SQL queries
    • INSERT/DELETE/UPDATE statements
  • TimesTen-only SQL and built-in procedures
  • PL/SQL constructs
• Mappings between Oracle and TimesTen data types

12 SQL*Plus Scripts for Oracle In-Memory Database Cache

• Installed SQL*Plus scripts

Glossary

Index