Oracle TimesTen Sample Utilities Downloads

You must accept the OTN License Agreement to download this software.
Accept License Agreement | Decline License Agreement
The following utilities are not officially certified by Oracle. They are supported on a "best effort"  basis. If you have any questions or encounter issues with using these utilities, please post your questions to the OTN TimesTen Community.

ttImportFromOracle v3.6.0

A command-line utility that analyzes source tables in an Oracle database and generates scripts for importing the tables into a TimesTen database. The tool recommends space-efficient data types and compression candidates to further reduce the memory requirement for storage in the TimesTen database. It also generates an optimized loader script that performs data loading in parallel.

See the README for more info
     
 
Download
ttImportFromOracle for Linux x86 (64-bit) (853,426 bytes)
 
Download
ttImportFromOracle for Solaris Sparc (64-bit) (461,776 bytes)
 
Download
ttImportFromOracle for Windows (64-bit) (557,056 bytes)
 
Download
ttImportFromOracle for AIX (64-bit) (828,597 bytes)
 
Download
ttImportFromOracle for Solaris x86 (64-bit) (580,384 bytes)
 
Download
ttImportFromOracle for Windows x86 (32-bit) (452,096 bytes)
 
Download
ttImportFromOracle for Mac OS X (32-bit) (373,700 bytes)

ttSizeOra v1.1.0

A command-line utility that examines a table in an Oracle database and provides an estimate of the memory requirement for the table, its metadata and its indexes to be imported into a TimesTen database.

See the README for more info
     
 
Download
ttSizeOra for Linux x86 (64-bit) (853,426 bytes)
 
Download
ttSizeOra for Solaris Sparc (64-bit) (461,776 bytes)
 
Download
ttSizeOra for Windows (64-bit) (557,056 bytes)
 
Download
ttSizeOra for AIX (64-bit) (828,597 bytes)
 
Download
ttSizeOra for Solaris x86 (64-bit) (580,384 bytes)
 
Download
ttSizeOra for Windows x86 (32-bit) (452,096 bytes)
 
Download
ttSizeOra for Mac OS X (32-bit) (373,700 bytes)

ttindexadvisor.pl v1.2

For Oracle Exalytics, this perl script extracts the physical SQL queries from OBIEE nqquery log, and creates additional indexes that may speed up these queries in the TimesTen database.

See the README for more info
     
 
Download
ttindexadvisor.pl.zip (3,614 bytes)