What's New

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

New Features for Release 11.2.1

TimesTen Release 11.2.1 includes the following new features covered in this guide:

• Quick Start demos

  This release includes an optional Quick Start feature with introductory information and some new or reworked demo applications. Note that the demos have mostly the same names as in earlier releases, but in a different location.

  See "About the TimesTen Java demos" and install_dir/quickstart.html in your installation.

• Access control

  Perhaps the most significant overall change to previous functionality in this release is access control. TimesTen has new features to control database access with object-level resolution for database objects such as tables, views, materialized views, and sequences. This also affects access to certain TimesTen built-in procedures, utilities, and connection attributes.

  See "Considering TimesTen features for access control". For general information, see "Managing Access Control" in Oracle TimesTen In-Memory Database Operations Guide.

• OUT parameters

  TimesTen now supports OUT and IN OUT parameters for your database operations.

  See "Working with OUT and IN OUT parameters".

• Duplicate parameters

  TimesTen now supports either of two modes for binding duplicate parameters in a SQL statement. Use the DuplicateBindMode general connection attribute to choose between Oracle mode and traditional TimesTen mode.

  See "Binding duplicate parameters in SQL statements".

• REF CURSORs

  REF CURSOR is a PL/SQL concept, where a REF CURSOR is a handle to a cursor over a SQL result set and can be passed between PL/SQL and an application.

  See "Working with PL/SQL REF CURSORs".

• Automatic client failover

  Automatic client failover, used in High Availability scenarios when failure of a TimesTen node results in failover (transfer) to an alternate node, automatically reconnects applications to the new node. TimesTen provides features that allow applications to be alerted when this happens, so they can take any appropriate action.

  See "JDBC support for automatic client failover".

• DML returning (RETURNING INTO clause)

  You can use a RETURNING INTO clause, referred to as DML returning, with an INSERT, UPDATE, or DELETE statement to return specified items from a row that was affected by the action.

  See "Working with DML returning (RETURNING INTO clause)".

• Rowids

  Each row in a TimesTen database table has a unique identifier known as its rowid. TimesTen now supports Oracle-style rowids. An application can retrieve the rowid of a row from the ROWID pseudocolumn.

  See "Working with rowids".

• Execution time threshold for SQL statements

  You can configure TimesTen to write a warning to the support log and throw an SNMP trap when the execution of a SQL statement exceeds a specified time duration, in seconds. This feature was added in a 7.0.x maintenance release but not documented in this manual. Note that this feature is similar to but differs from the previously existing timeout value for SQL statements.

  See "Setting a timeout or threshold for executing SQL statements".

• JMS/XLA replicated bookmarks

  If you are using an active standby pair replication scheme, you now have the option of using replicated bookmarks. For a replicated bookmark, operations on the bookmark are replicated to the standby database as appropriate. This allows more efficient recovery of your bookmark positions in the event of failover.

  See the section on replicated bookmarks under "XLA bookmarks".

• Indication of XLA updates due to cascading deletes or aging

  TimesTen indicates if an XLA update was generated as part of a cascading delete or aging operation through new XLA flags.

  See "XLA flags".