2 Cache Concepts

Use caching to improve the performance for your applications access to data. You can cache Oracle Database data and reduce the workload on the Oracle database.

The TimesTen mechanism that enables read and write caching for Oracle database tables is called a cache group. A cache group can represent one or more related tables on an Oracle database. Each Oracle table is represented in the cache group with a cache table. You can read from or write to the cache tables. TimesTen connects to the backend Oracle database to load or update data as appropriate.

You can use cache in both TimesTen Classic and TimesTen Scaleout.

• TimesTen Classic supports all cache group types.

• TimesTen Scaleout supports static read-only cache groups.

See Cache Group Types.

This chapter includes the following topics:

• Overview of Cache Groups

• Cache Instance

• Cache Group Types

• Transmitting Changes Between the TimesTen and Oracle Databases

• Using Oracle GoldenGate as an Alternative Cache Refresh Mechanism

• High Availability Caching Solution