|
General |
|
- Support concurrent connections to TimesTen database and Oracle Database
- Support Oracle TimesTen In-Memory Database and TimesTen Application-Tier 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
|
|