Contents

Title and Copyright Information

Preface

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

1 Connecting to a TimesTen Database

• Setting environment variables for TimesTen and SQL Developer
• Defining a TimesTen database named connection
• Using an existing TimesTen database named connection
• Disconnecting an existing TimesTen database connection

2 Prerequisites to Creating and Accessing a Cache Environment

• Configuring the Oracle and TimesTen databases
• Set the cache administration user name and password
• Configure a cache grid
• Start and stop the cache agent

3 Creating Cache Groups

• Creating a cache group
  • Defining a cache group and cache table attributes
  • Defining the root table
    • Selecting the columns to cache
    • Specifying the table attributes
    • Specifying an aging policy
    • Verifying the root table definition
  • Defining the child tables
    • Selecting the columns to cache
    • Specifying the table attributes
    • Completing the definitions of the child tables
    • Verifying the cache group definition
• Dropping a cache group

4 Cache Group Operations

• Loading or refreshing a cache group
• Unloading a cache group
• Flushing a cache group

5 Cache Group and Cache Table Characteristics

• Viewing the characteristics of a cache group
  • Viewing the cache tables
  • Viewing the cache group definition
  • Viewing the aging attributes
• Altering the automatic refresh attributes of a cache group

6 Working with TimesTen Objects

• Locating a TimesTen database object
• Viewing the characteristics of a table
  • Viewing the columns
  • Viewing the indexes
  • Viewing the aging attributes
  • Viewing the table definition
• Creating an index on a table
• Creating a primary key constraint
• Changing the attributes of primary key
• Altering the aging properties of a table
  • Adding an aging policy to a table
  • Dropping an aging policy from a table
  • Changing the aging state of a table's aging policy
  • Changing the memory usage thresholds and LRU aging cycle
  • Changing the lifetime and cycle of a table's time-based aging policy
• Granting and revoking object privileges
• Viewing the privileges granted on a database object
• ttIsql commands in SQL worksheet

7 Interfacing with TimesTen Replication

• Viewing the replication scheme
  • Viewing the details of the TimesTen subscriber databases
  • Viewing the store attributes of the replicated TimesTen databases
• Starting the replication agent

8 Interfacing with the TimesTen Query Optimizer

• Updating the table and column statistics used by the query optimizer
• Viewing the execution plan of a statement

9 TimesTen Reports

• Generating TimesTen Reports
• About Your Database
• All Objects
• Database Administration
• PLSQL
• Security
• Table

Index