This section summarizes the new features of TimesTen supported in Oracle SQL Developer Release 4.0. There are some features that are only supported in TimesTen Release 11.2.2.5 or later. If a feature is only supported in TimesTen Release 11.2.2.5 or later, it will be noted.
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.
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 a cache grid, cache group, or cache table. For more information, see "Loading data from an Oracle database into a TimesTen database".
Features supported in TimesTen Release 11.2.2 or later:
You can define and use LOB data types. This includes defining columns with LOB data types, adding columns with LOB data types, displaying LOB data types, and defining LOB data types in IN
, OUT
, and IN OUT
parameters in PL/SQL editors. For more information, see "Specifying and displaying LOB data types".
You can compute table size information. For more information on computing table size information, see "Computing table size information".
For table reports, there are reports for Table Sizes and Column reports will display LOB data types if applicable. For information on table reports, see "Table".
Features supported in TimesTen Release 11.2.1.4.0 or later:
You can specify INLINE
when you define columns. For more information, see "Specifying the INLINE attribute for columns".
You can test your PL/SQL function, procedure, or package using a REF CURSOR
as an OUT
parameter. For more information, see "Using a REF CURSOR as an OUT parameter".
You can load data into tables. For more information, see "Loading data into tables".
There are reports for Cache Groups. For more information, see "Cache Groups".