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.7.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,226 bytes)
 
Download
 ttImportFromOracle for Solaris Sparc (64-bit) (461,776 bytes)
 
Download
 ttImportFromOracle for Windows (64-bit) (505,856 bytes)
 
Download
 ttImportFromOracle for AIX (64-bit) (828,739 bytes)
 
Download
 ttImportFromOracle for Solaris x86 (64-bit) (579,952 bytes)
 
Download
 ttImportFromOracle for Windows x86 (32-bit) (452,096 bytes)
 
Download
 ttImportFromOracle for Mac OS X (32-bit) (373,700 bytes)
 
Download
 ttImportFromOracle for Mac OS X (64-bit) (374,516 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)
 
Download
 ttSizeOra for Mac OS X (64-bit) (374,516 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)
 

ttSrcScan v11.2.2.8
The TimesTen source code scanner ttSrcScan, is a command-line utility that is used to check for possible unsupported functionality when using PL/SQL, OCI, Pro*C, and ODP.NET with TimesTen 11.2.2. ttSrcScan is a standalone utility, it can be run without installing TimesTen In-Memory Database or Oracle Database. It reads source code files as input, and the results from the scan are published in HTML reports.

See the README for more info
     
 
Download
 ttSrcScan for Linux x86 (64-bit) (4,557,787 bytes)
 
Download
 ttSrcScan.exe for Windows (64-bit) (4,500,480 bytes)