1. Introduction
  2. Caching in TimesTen
  3. Passthrough Feature

Passthrough Feature

Applications use a single connection to a cache to send SQL statements to either a cache group or to the Oracle database. This single-connection capability is enabled by a passthrough feature that checks whether the SQL statement can be handled locally by the cached tables in TimesTen or if it must be redirected to the Oracle database.

The passthrough feature provides settings that specify what types of statements are to be passed through and under what circumstances. The specific behavior of the passthrough feature is controlled by the PassThrough cache general connection attribute.

Figure 7-2 Passthrough Feature

Description of Figure 7-2 follows
Description of "Figure 7-2 Passthrough Feature"

See Setting a Passthrough Level in Oracle TimesTen In-Memory Database Cache Guide.