Contents

Title and Copyright Information

Preface

• Audience
• Release Support
• Related Documents
• Documentation Accessibility
• Conventions

1 Connecting to a TimesTen Database

• Set environment variables for TimesTen and SQL Developer
• Configure the Oracle and TimesTen databases
• Define a TimesTen database named connection
• Use an existing TimesTen database named connection
• Disconnect an existing TimesTen database connection

2 Prerequisites to Creating and Accessing a Cache Environment

• Set the cache administration user name and password
• Configure a cache grid
• Start and stop the cache agent

3 Creating Cache Groups

• Create a cache group
  • Define cache group and cache table attributes
  • Define the root table
    • Select the columns to cache
    • Specify the table attributes
    • Specify an aging policy
    • Verify the root table definition
  • Define the child tables
    • Select the columns to cache
    • Specify the table attributes
    • Complete the definitions of the child tables
    • Verify the cache group definition
• Create an index on a table
• Grant and revoke object privileges to and from database elements
• Drop a cache group

4 Cache Group Operations

• Load or refresh a cache group
• Unload a cache group
• Flush a cache group

5 Cache Group and Cache Table Characteristics

• View the characteristics of a cache group
  • View the aging attributes
  • View the cache tables
  • View the cache group definition
• Locate a TimesTen database element
• View the characteristics of a table
  • View the columns
  • View the indexes
  • View the aging attributes
  • View the table definition
• View the privileges granted on a database element
• Alter the automatic refresh attributes of a cache group
• Alter the aging properties of a table
  • Add an aging policy to a table
  • Drop an aging policy from a table
  • Change the aging state for a table's aging policy
  • Change the memory usage thresholds and LRU aging cycle
  • Change the lifetime and cycle for a table's time-based aging policy

6 Interfacing with TimesTen Replication

• View the characteristics of a replication scheme
  • View the details of the TimesTen subscriber databases
  • View the store attributes of the replicated TimesTen databases
• Start the replication agent

7 Interfacing with the TimesTen Query Optimizer

• Update the table and column statistics used by the query optimizer
• View the execution plan of a statement