Skip Headers
Oracle® In-Memory Database Cache User's Guide
Release 11.2.1
Part Number E13073-11
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
Technical support
What's New
New features in Release 11.2.1.7.0
New features in Release 11.2.1.6.0
New features in Release 11.2.1.5.0
New features in 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
Modify the PROCESSES Oracle system parameter for ten or more grid nodes
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
Caching Oracle LOB data
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
Dynamic global cache groups
Explicitly loaded 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
Unloading a cache group across all grid members
Determining the number of cache instances affected by an operation
Setting a passthrough level
PassThrough=0
PassThrough=1
PassThrough=2
PassThrough=3
PassThrough=4
PassThrough=5
Considerations for using passthrough
Changing the passthrough level for a connection or transaction
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
Performing global queries on a cache grid
Restrictions on global queries
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
Recovering after failure of a grid node
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 an Oracle RAC Environment
How IMDB Cache works in an Oracle RAC environment
Restrictions on using IMDB Cache in an Oracle RAC environment
Setting up IMDB Cache in an Oracle RAC environment
10
Using Oracle In-Memory Database Cache with Data Guard
Components of MAA for Oracle In-Memory Database Cache
How IMDB 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
Scripting on this page enhances content navigation, but does not change the content in any way.