Oracle TimesTen In-Memory Database release 22.214.171.124 is available for download
By Sam Drake on Dec 12, 2013
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 release notes.
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 Active-Standby pairs
It is now possible to change the cache administrator password without dropping and re-deploying the active-standby pair.
Integration with SQL Developer 4.0
This release supports, and is supported by, SQL Developer 4.0. The following new features are available as part of this integration:
· Data Loading wizard for populating TimesTen tables using existing data from the Oracle Database
· Index Advisor wizard for query performance tuning
· Performance Metrics wizard to simplify performance reporting
TimesTen Quick Start Guide:
Some additional 'best practices' sections have been added to the TimesTen Quick Start Guide while other material has been updated.
TimesTen 126.96.36.199.0 is available immediately on all supported platforms.
Download Oracle TimesTen now!
Oracle TimesTen 188.8.131.52 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.