1/10
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
Scripting on this page enhances content navigation, but does not change the content in any way.