1/18

Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 18.1.4.1.0
• New features in Release 18.1.3.1.0
• New features in Release 18.1.2.2.0
• New features in Release 18.1.2.1.0
• New features in Release 18.1.1.1.0

1 TimesTen Application-Tier Database Cache Concepts

• 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
• High availability caching solution

2 Getting Started

• Setting up the Oracle Database and TimesTen Classic 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 cache groups
  • Create the Oracle Database tables to be cached
  • Start the cache agent
  • Create the cache groups
  • Start the replication agent for the AWT cache group
• Performing operations on the read-only cache group
  • Manually load the cache group
  • Update the cached Oracle Database table
• Performing operations on a dynamically updatable cache group
  • Dynamically load the cache group
  • Update the TimesTen cache table
• Cleaning up the TimesTen Classic and Oracle Database systems
  • Stop the replication agent
  • Drop the cache groups
  • Stop the cache agent and destroy the TimesTen database
  • Drop the Oracle Database users and their objects

3 Setting Up a Caching Infrastructure

• Configuring your system to cache Oracle Database data in TimesTen Classic
  • TimesTen Cache environment variables for UNIX or Linux
  • TimesTen Cache environment variables for Microsoft Windows
• Configuring the Oracle database to cache data in TimesTen Classic
  • Create the Oracle database users
  • Grant privileges to the Oracle database users
  • Automatically create Oracle Database objects used to manage data caching
  • Manually create Oracle Database objects used to manage data caching
• Configuring a TimesTen database to cache Oracle Database 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
• 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
    • Configuring parallel propagation to Oracle Database tables
    • 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
    • Restrictions with SWT cache groups
  • User-managed cache group
    • READONLY cache table attribute
    • PROPAGATE cache table attribute
    • Examples of user-managed cache groups
  • AUTOREFRESH cache group attribute
    • AUTOREFRESH cache group attribute overview
    • Altering a cache group to change the AUTOREFRESH mode, interval or state
    • Manually creating Oracle Database objects for autorefresh cache groups
    • Disabling full autorefresh for cache groups
  • Using a WHERE clause
    • Proper placement of WHERE clause in a CREATE CACHE GROUP statement
    • Referencing Oracle Database PL/SQL functions in a WHERE clause
  • ON DELETE CASCADE cache table attribute
  • UNIQUE HASH ON cache table attribute
• Caching Oracle Database synonyms
• Caching Oracle Database LOB data
• Implementing aging in a cache group
  • LRU aging
  • Time-based aging
  • Manually scheduling an aging process
  • Configuring a sliding window
• Dynamic cache groups
• Replicating cache tables
  • Create and configure the active database
  • Create and configure the standby database
  • Create and configure the read-only subscriber database

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 autorefresh
  • Loading and refreshing a dynamic cache group with autorefresh
  • Loading and refreshing a cache group using a WITH ID clause
  • Initiating an immediate autorefresh
  • 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 instance
  • Dynamic load configuration
  • Dynamic load guidelines
  • Examples of dynamically loading a cache instance
  • Returning 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
  • PassThrough=0
  • PassThrough=1
  • PassThrough=2
  • PassThrough=3
  • Considerations for using passthrough
  • Changing the passthrough level for a connection or transaction

6 Managing a Caching Environment

• Checking the status of the cache and replication agents
  • Cache agent and replication connections
• Monitoring cache groups
  • Using the ttIsql utility's cachegroups command
  • Monitoring autorefresh operations on cache groups
  • Monitoring AWT cache groups
  • Configuring a transaction log file threshold for AWT cache groups
  • Tracking DDL statements issued on cached Oracle Database tables
• Managing a caching environment with Oracle Database objects
• Impact of failed autorefresh operations on TimesTen databases
• Dropping Oracle Database objects used by autorefresh cache groups
• Monitoring the cache administration user's tablespace
  • Defragmenting change log tables in the tablespace
    • Manually defragmenting the change log tables for autorefresh cache groups
  • Receiving notification on tablespace usage
  • Recovering from a full tablespace
• Backing up and restoring a database with cache groups
  • Backing up and restoring using the ttBackup and ttRestore utilities
  • Backing up and restoring with the ttMigrate utility
• Changing cache user names and passwords

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
    • Apply cache connection pool sizing to currently executing database
    • Example demonstrating management of the cache connection pool
    • Limit the number of connections to the Oracle database
    • Restrictions for the cache connection pool
• Improving AWT throughput
  • Improving AWT throughput with parallel propagation
  • Improving AWT throughput with SQL array execution
• Improving performance for autorefresh operations
  • Minimizing delay for cached data with continuous autorefresh
  • Reducing contention on TimesTen for dynamic read-only cache groups with incremental autorefresh
    • Requirements for setting DynamicLoadReduceContention
  • Reducing lock contention for read-only cache groups that use autorefresh and dynamic load
  • Improving performance when reclaiming memory during autorefresh operations
  • Executing large transactions with incremental autorefresh read-only cache groups
    • Using ttCacheAutorefreshXactLimit
    • Example of potential transactional inconsistency
    • Retrieving statistics to evaluate performance when a transaction limit is set
  • Configuring a select limit when using incremental autorefresh for read-only cache groups
    • How to determine the cache group name for a particular select limit
    • Retrieving statistics to evaluate performance when using a select limit
• Retrieving statistics on autorefresh transactions
• Caching the same Oracle table on two or more TimesTen databases

8 Cleaning up the Caching Environment

• Stopping the replication agent
• Dropping a cache group
• Stopping the cache agent
• Destroying the TimesTen databases
• Dropping Oracle Database users and objects
• Scheduling a shutdown of active standby pair with AWT cache groups

9 Using TimesTen Cache in an Oracle RAC Environment

• How TimesTen Cache works in an Oracle RAC environment
• Restrictions on using TimesTen Cache in an Oracle RAC environment
• Setting up TimesTen Cache in an Oracle RAC environment

10 Using TimesTen Cache with Data Guard

• Components of MAA for TimesTen Cache
• TimesTen Cache works with asynchronous Active Data Guard
  • Configuring the primary and standby Oracle databases
    • Creating two Oracle Database services
  • Configuring the active standby pair with read-only cache groups
  • Recovery after failure when using asynchronous Active Data Guard
    • Failure of the standby Oracle database
    • Failure of the primary Oracle database
    • Failure of the primary site
• TimesTen Cache works with synchronous Data Guard
  • Configuring the Oracle databases
  • Configuring the TimesTen database

A Procedure and Privileges for Caching Oracle Database Data in TimesTen Classic

• Quick reference to cache Oracle Database data in TimesTen Classic
• Required privileges for the cache administration user and the cache manager user

B SQL*Plus Scripts for TimesTen Cache

• Installed SQL*Plus scripts

C Compatibility Between TimesTen and Oracle Databases

• Summary of compatibility issues
• Transaction semantics
• API compatibility
  • JDBC API compatibility
    • java.sql.Connection
    • java.sql.Statement
    • java.sql.ResultSet
    • java.sql.PreparedStatement
    • java.sql.CallableStatement
    • java.sql.ResultSetMetaData
    • Stream support
  • ODBC API compatibility
• SQL compatibility
  • Schema objects
    • Caching Oracle Database partitioned tables
  • Nonschema objects
  • Differences between Oracle Database and TimesTen tables
  • Data type support
  • SQL operators
  • SELECT statements
  • SQL subqueries
  • SQL functions
  • SQL expressions
  • INSERT/DELETE/UPDATE/MERGE statements
  • TimesTen-only SQL and built-in procedures
  • PL/SQL constructs
• Mappings between Oracle Database and TimesTen data types

Index