This section summarizes the new features of Oracle TimesTen In-Memory Database 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. They DynamicLoadEnable connection attribute has been enhanced to support this feature. See "DynamicLoadEnable".
This release contains a new built-in procedure that allows applications to recompile or invalidate dependent commands. See "ttOptCmdCacheInvalidate".
The ttAdmin utility is enhanced to allow users to determine if a database is automatically reloaded after a failure. The utility has the new options -autoreload and -noAutoReload. See "ttAdmin".
In a ttRepAdmin -duplicate operation, now you can specify a local or remote IP address for the destination of the duplicate, using the options -localIPAddress and -remoteIPAddress. See "Duplicate a database".
This release includes a new built-in procedure ttGridFirstMemberAttach that enables grid recovery. In the case that all attached members of the grid have died, call this built-in instead of ttGridAttach to attach the first member of the grid. For a description of this procedure and its use, see "ttGridFirstMemberAttach".
The system limits are now documented in Oracle TimesTen In-Memory Database System Tables and Limits Reference.
You can perform a global query on cache tables and noncache tables across all nodes in a cache grid. Also, you can unload a cache group on all grid members by specifying a global unload operation. See the description of the optimizer hint "GlobalProcessing".
If your application has predictable transactional dependencies and does not require the commit order on the target database be the same as the order on the source database, then you can increase replication throughput by configuring parallel replication. See the descriptions for these new attributes:
Additional support for Clusterware. New options are available with the ttCWAdmin utility that allow users to add and delete master and subscriber hosts dynamically.
See the ttCWAdmin utility.
PL/SQL
See "PL/SQL first connection attributes" and "PL/SQL general connection attributes" in Chapter 1, "Connection Attributes."
Additional cache features
See the ttCacheAutorefresh built-in procedure.
Additional Cache grid features.
See the ttGridDetachAll, ttGridGlobalCGResume, and ttGridGlobalCGSuspend built-in procedures.
Support for synonyms
See ttIsql utility and the PassThrough connection attribute.
Cache grid.
See the CacheGridEnable and CacheGridMsgWait connection attributes and the ttGridAttach, ttGridCreate, ttGridDestroy, ttGridDetach, ttGridDetachList, ttGridInfo, ttGridNameSet and ttGridNodeStatus built-in procedures.
Dynamic cache groups.
See the DynamicLoadEnable and DynamicLoadErrorMode connection attributes and the ttCacheSqlGet built-in procedure.
Client/Server automatic failover.
See "TimesTen Client connection attributes" in Chapter 1, "Connection Attributes."
Additional passthrough features.
See the PassThrough connection attribute, the ttOptSetFlag built-in procedure and the ttIsql utility.
Oracle-style DDL commit behavior.
See the DDLCommitBehavior connection attribute.
SQL command cache.
See the ttSQLCmdCacheInfoGet and ttSQLCmdQueryPlan built-in procedures.
Parallel log manager.
See the LogBufParallelism first connection attribute.
New features specific to support for PL/SQL in TimesTen:
New connection attributes to support and configure PL/SQL in TimesTen.
See PL/SQL first connection attributes and PL/SQL general connection attributes.
New ttIsql commands to display PL/SQL functions, packages, procedures and more.
See the ttIsql utility.
New features specific to replication:
Support for Oracle Clusterware.
See the ttCWAdmin utility.
Replication query threshold settings.
See the ttRepQueryThresholdGet and ttRepQueryThresholdSet built-in procedures and the ttAdmin utility.