Oracle SQL Developer 4.0 - TimesTen Features List


 
SQL Developer 4.0 provides the following TimesTen In-Memory Database and In-Memory Database Cache (TimesTen) features:
 
General
 
  • Support concurrent connections to TimesTen database and Oracle Database
  • Support Oracle TimesTen and In-Memory Database Cache 11g Release 1 and Release 2
  • Available on Linux and Windows 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
 
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