Oracle TimesTen In-Memory Database release 11.2.2.6 is available for download

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.

Feature highlights:

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.

Platform Availability:

TimesTen 11.2.2.6.0 is available immediately on all supported platforms.

Download Oracle TimesTen now!

Oracle TimesTen 11.2.2.6 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.

Comments:

Is it easily supported on migrating from an Oracle Database to Timesten? Specially migrating data by creating a dump from Oracle and import in a Timesten database?

Posted by guest on December 12, 2013 at 11:10 PM PST #

Good question! There are a number of ways to copy data from an Oracle Database into TimesTen. Here are just a few:

* TimesTen provides a builtin procedure, ttLoadFromOracle, which will cause TimesTen itself to connect to an Oracle Database and copy over data, loading it into a TimesTen table directly. Options can be specified to cause the data copying to be done in parallel by a number of threads for fastest performance. (Another builtin, ttTableSchemaFromOraQueryGet, will generate an appropriate CREATE TABLE statement for you, too.)

* As the article mentions, SQL Developer 4.0 can be used to drive these facilities through a convenient graphical interface.

* For users who license the Oracle In-Memory Database Cache, the caching facilities of TimesTen make it easy to copy data from Oracle into TimesTen, and then propagate further changes from one database to the other.

So yes, it should be simple to copy data from an Oracle Database into TimesTen!

...Sam

Posted by Sam Drake on December 13, 2013 at 12:06 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

This blog will cover the Oracle TimesTen In-Memory Database and the Oracle Database's In-Memory Database Cache Option ... which is also based on TimesTen. The blog is maintained by Sam Drake. He has worked on the TimesTen product for more than 15 years, and is presently an Architect working in TimesTen development at Oracle.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today