What's New

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.

New features in Release 11.2.1.6.0

• 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:

  • "ReplicationApplyOrdering".

  • "ReplicationParallelism".

  • "ReplicationTrack".

New features for Release 11.2.1.5.0

• 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.

New features for Release 11.2.1.4.0

• 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.

New features for Release 11.2.1.1.0

• 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.