What's New

This section summarizes the new features and functionality of Oracle TimesTen In-Memory Database Release 11.2.2 that are documented in this guide, providing links into the guide for more information.

• New features in release 11.2.2.4.0

• New features in release 11.2.2.2.0

• New features in release 11.2.2.1.0

• New features in release 11.2.2.0.0

New features in release 11.2.2.4.0

• 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. For more details, see "Using the Index Advisor to recommend indexes".

• 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. For more information, see "Loading Oracle data into a TimesTen table".

• You can defragment a TimesTen database with the ttMigrate utility. For full details, see "Defragmenting TimesTen databases".

  To defragment multiple databases with minimal overall service downtime, use a combination of the ttMigrate and ttRepAdmin -duplicate utilities to defragment TimesTen databases that are involved in an active standby pair replication scheme. For details, see "Online defragmentation of TimesTen databases".

New features in release 11.2.2.2.0

• You can now declare, use, and set bind variables within ttIsql with the variable and setvariable commands. In addition, automatic bind variables can also be created. See "Using, declaring, and setting variables" for more details.

• You can cancel an ODBC function with Ctrl-C. See "Canceling ODBC functions" for more details.

• Use the WHENEVER SQLERROR command to control error recovery within ttIsql. For more details, see "Error recovery with WHENEVER SQLERROR".

• Use the IF-THEN-ELSE command construct to to implement conditional branching logic in a ttIsql session. See "Conditional control with the IF-THEN-ELSE command construct" for more details.

New features in release 11.2.2.1.0

• It is important to verify at frequent intervals that there are no transaction log holds that could result in an excessive accumulation of transaction log files. If too many transaction log files accumulate and fill up available disk space, new transactions in the TimesTen database cannot begin until the transaction log hold is advanced and transaction log files are purged by the next checkpoint operation. See "Monitoring accumulation of transaction log files" for more details.

• The LOB data type is now supported. See "SQL string and character functions" for more details.

New features in release 11.2.2.0.0

• Range indexes used to be referred to as T-tree indexes. Now all output and commands use range as the identifying terminology. In "Viewing and changing query optimizer plans", the showplan command now takes tryrange and trytmprange as options and the output for the query plan shows range indexes, such as TmpRangeScan.

• There is a new tablesize command within ttIsql that shows the actual sizes of tables within the TimesTen database. For full details, see "Using the ttIsql tablesize command".