Table of Contents
- Title and Copyright Information
- About This Content
- What's New
- 1 Paths to Explore Cache in TimesTen
- 2 Cache Concepts
-
3
Setting Up a Caching Infrastructure
- Configuring the Oracle Database to Cache Data
- Configuring a TimesTen Database to Cache Oracle Database Data
- Testing the Connectivity Between the TimesTen and Oracle Databases
- Managing the Cache Agent
-
4
Defining Cache Groups
- Cache Groups and Cache Tables
- Creating a Cache Group
- Read-Only Cache Group
-
Asynchronous WriteThrough (AWT) Cache
Group
- Starting and Stopping the Replication Agent
- Setting a Replication Agent Start Policy
- Monitoring Propagation of Transactions to the Oracle Database
- Disabling Propagation of Committed Changes
- Configuring Parallel Propagation to the Oracle Database
- What an AWT Cache Group Does and Does Not Guarantee
- Restrictions with AWT Cache Groups
- Reporting Oracle Database Permanent Errors for AWT Cache Groups
- Synchronous WriteThrough (SWT) Cache Group
- Hybrid Cache Group
- User Managed Cache Group
- Using a WHERE Clause
- Specifying Automatic Refresh with the AUTOREFRESH Cache Group Attribute
- Creating a Dynamic Cache Group with the DYNAMIC Keyword
- Creating a Hash Index on the Primary Key Columns of the Cache Table
- ON DELETE CASCADE Cache Table Attribute
- Caching Oracle Database Synonyms
- Caching Oracle Database LOB Data
- Implementing Aging in a Cache Group for TimesTen Classic
- Replicating Cache Tables in TimesTen Classic
-
5
Methods for Transmitting Changes Between
TimesTen and Oracle Databases
-
Manually Loading and Refreshing a Cache
Group
- Loading and Refreshing a Cache Group Using a WITH ID Clause
- 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 a Static Cache Group
- Example of Manually Loading and Refreshing a Dynamic Cache Group
- Flushing a User Managed Cache Group
- Unloading a Cache Group
-
Automatically Refreshing a Cache Group
- AUTOREFRESH Cache Group Attribute Overview
- Altering a Cache Group to Change the AUTOREFRESH Mode, Interval or State
- Manually Creating Oracle Database Objects for Cache Groups with Autorefresh
- Initiating an Immediate Autorefresh in TimesTen Classic
- Disabling Full Autorefresh for Cache Groups
- Loading and Refreshing a Static Cache Group with Autorefresh
- Loading and Refreshing a Dynamic Cache Group with Autorefresh
- Manually or Dynamically Loading Cache Groups
- Dynamic Cache Groups
- Determining the Number of Cache Instances Affected by an Operation
- Setting a Passthrough Level
-
Manually Loading and Refreshing a Cache
Group
-
6
Managing a Caching Environment
- Checking the Status of Cache and Replication Agents
- Cache Agent and Replication Connection Recovery
- Managing a Cache Environment with Oracle Database Objects
- Monitoring Cache Groups
- Changing Cache User Names and Passwords
- Dropping Oracle Database Objects Used by Cache Groups with Autorefresh
- Impact on Cache Groups When Modifying the Oracle Database Schema
- Impact of Failed Autorefresh Operations on TimesTen Databases
- Managing the Cache Administration User's Tablespace
- Backing Up and Restoring a TimesTen Classic Database with Cache Groups
- Migrating the Oracle Database Requires Cleaning Up Cache Objects
-
7
Cache Performance
-
Dynamic Load Performance
-
Managing a Cache Connection Pool to the Oracle
Database for Dynamic Load Requests
- Enable the Cache Connection Pool
- Size the Cache Connection Pool
- Use the ChildServer Connection Attribute to Identify a Child Server Process
- Dynamically Applying Cache Connection Pool Sizing Modifications
- Example Demonstrating Management of the Cache Connection Pool
- Limiting the Number of Connections to the Oracle Database
- Restrictions for the Cache Connection Pool
-
Managing a Cache Connection Pool to the Oracle
Database for Dynamic Load Requests
- Improving AWT Throughput
-
Improving Performance for Autorefresh
Operations
- Minimizing Delay for Cached Data with Continuous Autorefresh
- Reducing Contention for Dynamic Read-Only Cache Groups with Incremental Autorefresh
- Reducing Lock Contention for Read-Only Cache Groups with Autorefresh and Dynamic Load
- Options for Reducing Contention Between Autorefresh and Dynamic Load Operations
- Improving Performance When Reclaiming Memory During Autorefresh Operations
- Running Large Transactions with Incremental Autorefresh Read-Only Cache Groups
- Configuring a Select Limit for Incremental Autorefresh for Read-Only Cache Groups
- Retrieving Statistics on Autorefresh Transactions
- Caching the Same Oracle Table on Two or More TimesTen Databases
-
Dynamic Load Performance
- 8 Cleaning Up the Caching Environment
- 9 Using Cache in an Oracle RAC Environment
-
10
Using Cache with Data Guard
- Components of MAA for Cache
- Cache in TimesTen Works with Asynchronous Active Data Guard
- Cache in TimesTen Works with Synchronous Data Guard
-
11
Using GoldenGate as an Alternative
to Native Read-Only Cache Groups
- Supporting TimesTen and GoldenGate for Cache Refresh
- Considering Factors Using GoldenGate as the Cache Refresh Mechanism
-
Configuring GoldenGate to Provide
Cache Refresh Functionality for TimesTen Workflow
- Choosing On-Box or Off-Box for Deployment of a GoldenGate Replicat Process
- Installing and Configuring Target TimesTen Database
- Creating TimesTen Database Users and Tables
- Installing and Configuring a TimesTen Client Instance (for Off-Box Deployments Only)
- Configuring GoldenGate Data Apply
- Performing an Initial Load
- Starting GoldenGate Continuous Real-Time Replication
- Caching Using GoldenGate Example
- A Required Privileges for Cache Administration User for Cache Operations
- B SQL*Plus Scripts for Cache
-
C
Compatibility Between TimesTen and Oracle Databases
- Summary of Compatibility Issues
- Transaction Semantics
- API Compatibility
- SQL Compatibility
- Mappings Between Oracle Database and TimesTen Data Types