This release provides new capabilities that
further improve performance and scalability for applications with extremely
fast response time and very high throughput requirements, specifically for
Online Transaction Processing (OLTP) workloads and Business Intelligence (BI)
in-memory analytics workloads for the Oracle Exalytics In-Memory Machine. The release also contains bug fixes as detailed in the
Performance for In-Memory Analytics
Significant improvements to the SQL Optimizer
and Execution engine for in-memory analytics. These improvements both reduce
query prepare time while also enabling better plan generation resulting in
improved query response time for certain types of query. In particular, the
performance of queries using star-joins and left outer joins has been improved.
Ability to interrupt data loading
It is now possible to interrupt an in
progress data load that is using the ttLoadFromOracle builtin. The load can be
interrupted using the SQLCancel ODBC function, the Statement.cancel() JDBC
method or, in ttIsql, by pressing Ctrl-C.
Improved SQL support
Support is added for constant expressions,
dynamic parameters, and NULL values in the values lists used for IN, ANY, SOME, or ALL.
Improved manageability of Clusterware managed
It is now possible to change the cache
administrator password without dropping and re-deploying the active-standby
Integration with SQL
This release supports, and is supported by,
SQL Developer 4.0. The following new features are available as part of this
Loading wizard for populating
TimesTen tables using existing data from the Oracle Database
Advisor wizard for query
Metrics wizard to simplify
TimesTen Quick Start Guide:
Some additional 'best practices' sections
have been added to the TimesTen Quick Start Guide while other material has been
TimesTen 18.104.22.168.0 is available immediately
on all supported platforms.
Download Oracle TimesTen now!
Oracle TimesTen 22.214.171.124 release supports the
following licensed products in the TimesTen product family: Oracle TimesTen In-Memory Database; Oracle TimesTen In-Memory Database for Exalytics; Oracle In-Memory Database Cache; and In-Memory Database Cache for Oracle Applications.