SQL Developer 2.1 supports both TimesTen (and In-Memory Database Cache) 11g and 7.0. It contains the following new TimesTen features:
* In-Memory Database Cache
o Create, Drop, Alter, Load, Refresh, Unload and Flush Cache Groups
o Start and Stop Cache and Replication Agents
o Set and Change Cache Administration User
* PL/SQL support*
o Create, Drop, Edit, Compile, Run and Export PL/SQL subprograms (Packages, Procedures, Functions)
* Privileges* - Grant, Revoke and View object privileges
* Aging - Define, Alter and View aging policies on cache and regular tables
* Statistics - Update and View table/column statistics
* Plans - Show SQL execution plans
* Index* - Creation of Bitmap indexes
* Applicable to TimesTen 11g only
Software Downloads and Documentation
* The download for SQL Developer 2.1 Early Adapter 1 is available on OTN
* Please refer the Release Notes and the User’s Guide for more information.
文章 (RSS)