Oracle SQL Developer - TimesTen Features List

SQL Developer provides the following TimesTen In-Memory Database and TimesTen Application-Tier Database Cache (TimesTen) features:

General

  • Support concurrent connections to TimesTen database and Oracle Database
  • Support Oracle TimesTen In-Memory Database and TimesTen Application-Tier Database Cache 11.2.2.8.x and 18.1.x (both TimesTen Classic [standalone single node] and TimesTen Scaleout [distributed over multiple nodes] )
  • Available on Linux, Windows and macOS platforms

Database Objects

  • Create and drop users, change user password, grant, revoke and view system and object privileges
  • Browse, create, and edit TimesTen database objects including tables, views, indexes, sequences, synonyms, materialized views, materialized view logs, PL/SQL packages, procedures and functions
  • Filter and narrow the list of objects displayed while browsing database schema
  • Define and alter data aging policies on tables
  • Support a number of data types including LOB (large object) data types
  • Query, update and delete data in regular and cache tables
  • Export data from Oracle and TimesTen tables in ttBulkCp format, and import data to TimesTen tables
  • Compute table size, update and view table and column statistics

PL/SQL, Worksheet and Reports

  • Create, edit, compile and run PL/SQL packages, procedures and functions
  • Execute TimesTen built-in procedures and selected ttIsql commands in SQL Worksheet
  • View SQL execution plans from SQL Worksheet
  • Run pre-defined reports on TimesTen database objects including cache groups
  • Create and run user-defined reports

Importing Data from Oracle Database

  • Copy table definition and load data from Oracle Database to TimesTen
  • Support concurrent loads from multiple tables

Performance Monitoring and Tuning

  • Integrate with TimesTen utilities and built-in procedures designed for performance monitoring and tuning
  • Simplify the tasks of generating performance reports for a given workload
  • Analyse and recommend indexes for a specific workload using TimesTen Index Advisor

Scaleout

  • Test passwordless SSH configuration
  • Create and delete a TimesTen Installation
  • Create, manage and explore a TimesTen Scaleout grid and its components

Cache Group

  • Create and drop cache groups
  • Perform cache group operations, such as Load, Refresh, Unload and Flush
  • Alter cache data refresh intervals, status and aging properties of cache groups