|Oracle® TimesTen In-Memory Database Reference
Part Number E13069-13
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
-noAutoReload. See "ttAdmin".
ttRepAdmin -duplicate operation, now you can specify a local or remote IP address for the destination of the duplicate, using the options
-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 "
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.
Additional cache features
See the ttCacheAutorefresh built-in procedure.
Additional Cache grid features.
Support for synonyms
See the CacheGridEnable and CacheGridMsgWait connection attributes and the ttGridAttach, ttGridCreate, ttGridDestroy, ttGridDetach, ttGridDetachList, ttGridInfo, ttGridNameSet and ttGridNodeStatus built-in procedures.
Dynamic cache groups.
Client/Server automatic failover.
Additional passthrough features.
Oracle-style DDL commit behavior.
See the DDLCommitBehavior connection attribute.
SQL command cache.
Parallel log manager.
See the LogBufParallelism first connection attribute.
New connection attributes to support and configure PL/SQL in TimesTen.
New ttIsql commands to display PL/SQL functions, packages, procedures and more.
See the ttIsql utility.