Oracle SQL Developer TimesTen In-Memory Database
  Support

 

Oracle SQL Developer is a graphical tool that enhances productivity and simplifies development tasks for database application developers.

Using SQL Developer with TimesTen is similar to using SQL Developer with Oracle Database. Users navigate the database connections and objects in the tree-based object browser. TimesTen database users can browse, create and edit database objects, such as tables, views, indexes and PL/SQL subprograms, the same way as they do with Oracle Database. Refer to the Connections demo and the Basic Operations demo for more details.

TimesTen SQL Developer works seamlessly with TimesTen product functionality to simplify the use of many TimesTen utilities and built-in procedures for administrative tasks and performance tuning.

Loading Data into a TimesTen Table

To quickly copy a table definition and data from the Oracle Database to TimesTen is easy to do. TimesTen SQL Developer supports loading tables, views or the result set of a SQL query from the Oracle Database using the underlying TimesTen built-in procedure ttLoadFromOracle. Refer to the Data Loading demo for more details.

Performance Metrics and Reporting

TimesTen collects a rich set of database performance metrics and statistics. Such information are maintained in the TimesTen System Tables. SQL Developer simplifies the tasks of retrieving performance metrics for a given workload using the TT_STATS package. Follow the ttStats demo on how to generate TTSTATS report.

TimesTen Index Advisor

The TimesTen database engine was developed with a cost-based SQL optimizer for query performance. Thus, optimal query performance relies on having proper indexes. The TimesTen Index Advisor analyses and recommends indexes for a specific workload. SQL Developer simplifies the tasks of running the Index Advisor. See the Index Advisor demo for more details.

TimesTen Application-Tier Database Cache

For users who are using the TimesTen Application-Tier Database Cache product option to cache Oracle Database tables in a TimesTen database, SQL Developer simplifies the tasks of creating TimesTen cache groups by browsing the table schema in the Oracle Database to select the desired tables, columns, and rows. Administrative tasks such as populating cache group with initial dataset, attribute settings for data refresh intervals, data aging policies, etc. are intuitive and customizable using SQL Developer. Refer to the Create and Load Cache Group demo on how to set up a cache group.

With concurrent connections to both the TimesTen database and the Oracle Database, users can visually see cache data synchronization within SQL Developer. For read-write cache groups, updates to the cache tables in TimesTen are propagated to the Oracle Database; for Read-Only cache groups, updates to the Oracle Database tables are refreshed to the TimesTen cache tables. Refer to the Browse and Edit Cache Data demo for more details.

Summary

SQL Developer with TimesTen enables users to:

  • Establish concurrent connections to TimesTen database and Oracle Database
  • Browse, create, and edit database objects and PL/SQL subprograms
  • Import and load data from the Oracle Database and from flat files
  • Execute SQL and PL/SQL statements and scripts
  • Create and configure cache groups for data caching from the Oracle Database
  • Execute TimesTen utilities and built-in procedures, such as Index Advisor, TT_STATS, ttLoadFromOracle
  • View and create reports

SQL Developer 4.0 supports TimesTen 11.2.1.4 and later releases.