What's New

This section summarizes the new features of Oracle TimesTen In-Memory Database 11g Release 2 (11.2.2) that are documented in this guide and provides links to more information.

New features in Release 11.2.2.4.0

• In a ttRepAdmin -duplicate operation, now you can specify a local or remote IP address for the destination of the duplicate, using the options -localIP and -remoteIP. See "Duplicate a database".

• A new tool, the Index Advisor, can be used to recommend a set of indexes that could improve the performance of a specific SQL workload. The Index Advisor consists of several built-in procedures. The procedures that make up the Index Advisor are:

  • ttIndexAdviceCaptureDrop

  • ttIndexAdviceCaptureEnd

  • ttIndexAdviceCaptureInfoGet

  • ttIndexAdviceCaptureOutput

  • ttIndexAdviceCaptureStart

• New tools have been added that enable you to load the results of a SQL query from a back-end Oracle database into a single table on TimesTen without creating a cache grid, cache group, and cache table to contain the results. TimesTen provides the tools that will execute a user provided SELECT statement on Oracle and load the result set into a table on TimesTen. The ttIsql utility is enhanced to include the LoadFromOracle command. In addition, two new built-in procedures are in this release as part of this feature:

  • ttLoadFromOracle

  • ttTableSchemaFromOraQueryGet

New features in Release 11.2.2.2.0

• The ttIsql utility now supports autovariables, showcurrenttime as a set/show attribute, the IF command, and WHENEVER error handling. See more details in the description of the ttIsql utility.

• The new Automatic parallel replication allows for the parallel replication and application of transactions changes to the receiving nodes in a replication scheme. See Chapter 1, "Connection Attributes" for more details on parallel replication.

New features in Release 11.2.2.1.0

• The ability to determine the current space usage of a table using the ttComputeTabSizes built-in procedure.

• The new Automatic parallel replication allows for the parallel replication and application of transactions changes to the receiving nodes in a replication scheme. See Chapter 1, "Connection Attributes" for more details on parallel replication.

• You can configure parallel propagation of changes in AWT cache tables to the corresponding Oracle tables. See Chapter 1, "Connection Attributes" for more details on parallel propagation.

• The maximum value of the LogBufMB and LogFileSize connection attributes has increased to 64GB on 64-bit systems.