Oracle TimesTen In-Memory Database Support Release Notes
This document provides late-breaking information as well as information that is not yet part of the formal documentation.
This document contains the following sections:
This section lists changes between releases:
There are new features. See New features in release 18.2.
Features supported in TimesTen In-Memory Database 18.1 or later:
You can use SQL Developer to work with TimesTen Scaleout databases. For more information, see "Working with TimesTen Scaleout" in the Oracle SQL Developer Oracle TimesTen In-Memory Database Support User's Guide.
There are new features. See New features in release 4.1.
Features supported in TimesTen Release 22.214.171.124 or later:
You can set a custom substitution character that TimesTen uses for variable substitution. By default, the
set define attribute is set to
off and uses the substitution character of
&. For more information on the set define
ttIsql attribute, see "ttIsql" in the Oracle TimesTen In-Memory Database Reference.
When you create a named connection to connect to a TimesTen database, the User specified connection type is now called Advanced.
You can set the Autocommit option directly from the New/Select Database Connection dialog. This new autocommit option is set at the connection level. In previous releases the autocommit option is set at the running instance level.
There are new features. See New features in release 4.0.
Features supported in TimesTen Release 126.96.36.199 or later:
You can capture
ttStats snapshots and generate
ttStats reports that compare two snapshots. A
ttStats snapshot is a collection of performance metrics. TimesTen collects performance metrics from TimesTen system tables, system views, and built-in procedures.
There are new pre-defined Performance reports. Performance reports are reports that show statistics information for the TimesTen database and statistics snapshots of the database. These reports are available in the Performance category of the TimesTen Reports.
Features supported in TimesTen Release 188.8.131.52 or later:
SQL Developer supports the TimesTen Index Advisor which can evaluate a SQL workload and recommend indexes. The indexes that the TimesTen Index Advisor recommends can improve the performance for the following: joins, single table scans, and
ORDER BY or
GROUP BY operations.
You can load data using parallel threads from an Oracle database into a TimesTen database without creating a cache grid, cache group, or cache table.
SQL Developer 18.2 is available on 64-bit Microsoft Windows, Linux systems, and macOS. SQL Developer 18.2 supports Oracle TimesTen In-Memory Database 184.108.40.206.0 and later, TimesTen Application-Tier Database Cache 220.127.116.11.0 and later, and TimesTen In-Memory Database 18.1, and can be used to connect to a TimesTen database that resides on any platform that is supported by the TimesTen software.
In a client/server environment, if you connect to the TimesTen server with an older release of the TimesTen client, then new features added to the newer release of the server are not supported.
When you use some Java 8 versions on Linux, the pie chart in the table distribution tab cannot be seen. The drop-down list for the pie chart and the bar chart may look distorted. As a workaround, select the bar chart to visualize the data.
To use SQL Developer 18.2 on Windows to manage TimesTen Scaleout or a TimesTen Scaleout database, install a TimesTen client (version 18.2 or higher) and set your environment variables with the
ttenv script. By default, the
ttenv script sets the
CLASSPATH environment variable to:
ttjdbc5.jar with Java Development Kit (JDK) 8 causes the Java Virtual Machine to crash. Depending on the available
.jar file, set your
CLASSPATH environment variable to use either
If you do not select "Autocommit," then TimesTen SQL operations within the Connections navigator are not always automatically committed. You must issue an explicit commit by either selecting Commit or by issuing the commit command in SQL Worksheet. If TimesTen encounters errors in your transaction, you must explicitly roll back the transaction by either selecting Rollback or by issuing the rollback command in SQL Worksheet.
If "Autocommit" is selected, then TimesTen SQL operations within the Connections navigator are automatically committed. A transaction in the SQL Worksheet is also automatically committed if there are no open tables in the transaction. If there are open tables, then the transaction in the worksheet is not automatically committed and you must issue an explicit commit by either selecting Commit or by issuing the commit command in SQL Worksheet.
To enable "Autocommit," select Tools, then select Preferences. In the Preferences dialog box, click the + to the left of the Database node to expand the node and select Advanced.
Setting the passthrough level to a value other than 0 can affect the SQL operations in the Connections navigator. Make sure this setting is reset to 0 when switching from issuing passthrough operations in SQL Worksheet back to the Connections navigator.
You can also create an unshared worksheet which uses a separate database connection from the Connections navigator so that a particular passthrough level setting applies only to that worksheet. From a shared worksheet, click the Unshared SQL Worksheet icon or press Ctrl+Shift+N to create an unshared worksheet.
If you click the + to the left of the Indexes node to view the list of indexes and then click the name of the index with the characteristics you want to view, you cannot view the index's DDL statement, because the SQL tab is missing. To view the
CREATE INDEX statement, from the index's underlying table or materialized view, click the SQL tab.
TimesTen error 2963 (
Inconsistent datatypes: (NUMBER,CHAR) are not compatible in expression) is returned when you attempt specify a numeric value filter on a numeric column. To specify a filter value for a numeric column, click the + to the left of the Tables node to view the list of tables, and then click the name of a table that contains a numeric column. In the Data tab of the table, click the name of a numeric column. In the Filter field, enter a numeric value and press the Enter key.
Before you export data from a table in a format that is compatible with the TimesTen
ttBulkCp utility, set the format for
TIMESTAMP data using the following instructions:
Select Tools, then select Preferences.
In the Preferences dialog box click the + to the left of the Database node to expand the node.
In the Date Format field, specify
In the Timestamp Format field, specify
To export data from a table in a format that the
ttBulkCp utility recognizes, right-click the name of the table and select Unload. After you select Unload, step 1 (Source/Destination) of the Unload Wizard appears. In the Format drop-down menu, select ttbulkcp. After you complete step 1, click the Next button to advance to step 2 (Specify Data) of the Unload Wizard. After you complete step 2, click the Next button to advance to step 3 (Unload Summary). Click the Finish button to complete the data export operation.
You can change the
TIMESTAMP data format back to their original settings after the data has been exported.
The hierarchical profile and debugging of PL/SQL procedures and functions in a TimesTen database are not supported.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle SQL Developer Oracle TimesTen In-Memory Database Support Release Notes, Release 18.2
Copyright © 2008, 2018, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.