This section summarizes the new features of TimesTen In-Memory Database supported in Oracle SQL Developer Release 18.2. There are some features that are only supported in TimesTen Scaleout. If a feature is only supported in TimesTen Scaleout, it will be noted.
Note:
In this document:Oracle TimesTen In-Memory Database in classic mode, or TimesTen Classic, refers to single-instance and replicated databases (as in previous releases)..
Oracle TimesTen In-Memory Database in grid mode, or TimesTen Scaleout, refers to multiple-instance distributed databases. TimesTen Scaleout is a grid of interconnected hosts running instances that work together to provide fast access, fault tolerance, and high availability for in-memory data. A grid contains one or more databases and each database is distributed across all instances of the grid.
TimesTen alone refers to both classic and grid modes (such as in references to TimesTen utilities, releases, distributions, installations, actions taken by the database, and functionality within the database).
You can alter a table that is already created. See "Edit a table" for more information.
Features supported in TimesTen In-Memory Database Release 18.1 or later:
You can use SQL Developer to work with a TimesTen Scaleout grid and TimesTen Scaleout databases. See "Working with TimesTen Scaleout" for more information. For more information on TimesTen Scaleout, see Oracle TimesTen In-Memory Database Scaleout User's Guide.
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 is a new Easy Client/Server connection type to connect to a TimesTen database. This new connection type allows you to connect to local and remote TimesTen databases without having to define a client DSN. For more information, see "Easy Client/Server".
Features supported in TimesTen Release 11.2.2.5 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. For more information, see "Working with TimesTen Performance Metrics".
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. For more information, see "Performance".
Features supported in TimesTen Release 11.2.2.4 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. For more information, see "Working with the TimesTen Index Advisor".
You can load data using parallel threads from an Oracle database into a TimesTen database without creating cache groups or cache tables. For more information, see "Loading data from an Oracle database into a TimesTen database".