This section summarizes the new features of Oracle In-Memory Database Cache release 11.2.1 that are documented in this guide and provides links to more information.
In a dynamic cache group, the data in its cache tables can be loaded on demand or manually. While dynamic cache groups have been around for several releases, in this release the dynamic cache group functionality has been expanded to include joins across tables that exist in multiple cache groups. For full details, see "Dynamically loading a cache instance".
You can create an explicitly loaded global cache group. See "Explicitly loaded global cache groups".
You can use the ttRepStateGet built-in procedure to return the grid state as well as the database role after failover in an active standby pair grid member. See "Recovering after failure of a grid node".
You can perform a global query on cache tables and noncache tables across all nodes in a cache grid. See "Performing global queries on a cache grid".
You can unload a cache group on all grid members by specifying a global unload operation. See "Unloading a cache group across all grid members".
You can cache Oracle CLOB, BLOB and NCLOB data as TimesTen VARCHAR2, VARBINARY or NVARCHAR2 data. See "Caching Oracle LOB data".
This section summarizes the new features of Oracle In-Memory Database Cache that are documented in this guide.
You can specify PL/SQL execution mode for AWT cache groups. See "Improving AWT throughput for mixed transactions and network latency".
You can specify a time unit of seconds for cache group aging. See "Implementing aging on a cache group".
You can initiate an immediate automatic refresh operation. See "Initiating an immediate automatic refresh".
You can suspend and resume operations on global AWT cache groups. See "Suspending global AWT cache group operations".
You can detach all of the cache grid members at once. See "Detaching a TimesTen database from a cache grid".
This section summarizes the new features of Oracle In-Memory Database Cache that are documented in this guide.
By default, you must create a cache grid to cache Oracle data in TimesTen databases. A cache grid provides read and write consistency on the cache tables among the TimesTen databases within the grid.
See "Configuring a cache grid" for information about defining a cache grid on one or more TimesTen databases.
Creating a global cache group allows data in its cache tables to be shared across multiple TimesTen databases within a cache grid. Only a dynamic asynchronous writethrough (AWT) cache group can be defined as a global cache group.
See "Global cache groups" for details about creating a global cache group.
With a local cache group, data in its cache tables are not shared across TimesTen databases regardless of whether the databases are members of the same cache grid. Any cache group type and category can be defined as a local cache group.
In a dynamic cache group, the data in its cache tables can be loaded on demand or manually. You can create a dynamic cache group for nearly any cache group type and classification.
See "Dynamic cache groups" for details about creating a dynamic cache group.
See "Dynamically loading a cache instance" for details about loading data into a dynamic cache group's cache tables.
With an explicitly loaded cache group, data is manually or automatically loaded into its cache tables. Any cache group type and classification can be defined as an explicitly loaded cache group.
You can enable tracking of DDL operations performed on Oracle tables that are cached in a TimesTen database. Tracking DDL operations on cached Oracle tables can be useful for monitoring or troubleshooting purposes.
See "Tracking DDL statements issued on cached Oracle tables" for details about enabling tracking of DDL operations on Oracle tables.
If a TimesTen database contains automatic refresh cache groups and the cache agent is not running on the database, automatic refresh operations are attempted, by default, but fail on those cache groups within that database. The failed automatic refresh attempts impacts the performance of automatic refresh operations on cache groups in other TimesTen databases that cache data from the same Oracle database.
Note:
An automatic refresh cache group refers to a read-only cache group or a user managed cache group that uses theAUTOREFRESH MODE INCREMENTAL cache group attribute.See "Impact of failed automatic refresh operations on TimesTen databases" for details about reducing the performance degradation in this situation and recovering the cache groups which failed to be automatically refreshed.
You can configure an action to occur when the cache administration user's tablespace becomes full. For automatic refresh cache groups, change log tables are created in the cache administration user's tablespace. When an update operation is issued on an Oracle table that is cached in one of these cache groups, the configured action is performed when there is no space available in the cache administration user's tablespace to insert a new row into the change log table.
See "Monitoring the cache administration user's tablespace" for details about the configured actions, and how to return a warning to the application when the cache administration user's tablespace usage exceeds a configured threshold.