SQL Developer support for TimesTen
Oracle SQL Developer is a graphical tool that enhances productivity and simplifies development tasks for database application developers. Using SQL Developer, TimesTen database users can browse, create, and edit database objects and PL/SQL subprograms; manage users and privileges; load, manipulate and export data; execute and tune SQL, PL/SQL statements and scripts; automate cache group operations; create and view performance reports.
Features
General
- Support concurrent connections to TimesTen database and Oracle Database
- Support Oracle TimesTen In-Memory Database and TimesTen Application-Tier Database Cache
- Available on Linux, Windows, and macOS platforms
Database Objects
- Create and drop users, change user passwords, grant, revoke and view system and object privileges.
- Browse, create, and edit TimesTen database objects including tables, views, indexes, sequences, synonyms, materialized views, PL/SQL packages, procedures, and functions.
- Filter and narrow the list of objects displayed while browsing the database schema.
- Define and alter data aging policies on tables.
- Support many 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 into 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.
Caching Support
- 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.
- 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.
- Analyze and recommend indexes for a specific workload using TimesTen Index Advisor.