Go to main content
1/17
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
Technical support
What's New
New features for release of SQL Developer 4.0
New features for release of SQL Developer 3.1
1
Connecting to a TimesTen Database
Setting environment variables for TimesTen and SQL Developer
Defining a TimesTen database named connection
DSN
Easy Client/Server
Advanced
Using an existing TimesTen database named connection
Disconnecting an existing TimesTen database connection
2
Working with TimesTen Objects
Locating a TimesTen database object
Specifying and displaying LOB data types
Specifying the INLINE attribute for columns
Computing table size information
Using a REF CURSOR as an OUT parameter
Viewing the characteristics of a table
Viewing the columns
Viewing the indexes
Viewing the aging attributes
Viewing the table definition
Creating an index on a table
Creating a primary key constraint
Changing the attributes of primary key
Creating a foreign key constraint
Dropping a constraint
Altering the aging properties of a table
Adding an aging policy to a table
Dropping an aging policy from a table
Changing the aging state of a table's aging policy
Changing the memory usage thresholds and LRU aging cycle
Changing the lifetime and cycle of a table's time-based aging policy
Granting and revoking object privileges
Viewing the privileges granted on a database object
Loading data into tables
ttIsql commands in SQL worksheet
3
Interfacing with the TimesTen Query Optimizer
Updating the table and column statistics used by the query optimizer
Exporting table statistics
Viewing the execution plan of a statement
4
Working with the TimesTen Index Advisor
Connection level capture
SQL worksheet
Including optimizer hints for Oracle BI server in a SQL worksheet
Saving index recommendations from a SQL worksheet
SQL workload script
Including optimizer hints for Oracle BI server for a SQL workload script
Database level capture
Saving index recommendations
Viewing the TimesTen index advisor capture state
5
Loading data from an Oracle database into a TimesTen database
Loading data from Oracle database tables
Adding an Oracle database schema
Removing an Oracle database schema
Applying a filter to Oracle database schema tables
Loading custom query results
Loading data from an Oracle database table into an existing TimesTen table
6
Prerequisites to Creating and Accessing a Cache Environment
Configuring the Oracle and TimesTen databases
Set the cache administration user name and password
Configure a cache grid
Start and stop the cache agent
7
Creating Cache Groups
Creating a cache group
Defining a cache group and cache table attributes
Defining the root table
Selecting the columns to cache
Specifying the table attributes
Specifying an aging policy
Verifying the root table definition
Defining the child tables
Selecting the columns to cache
Specifying the table attributes
Completing the definitions of the child tables
Verifying the cache group definition
Dropping a cache group
8
Cache Group Operations
Loading or refreshing a cache group
Unloading a cache group
Flushing a cache group
9
Cache Group and Cache Table Characteristics
Viewing the characteristics of a cache group
Viewing the cache tables
Viewing the cache group definition
Viewing the aging attributes
Altering the automatic refresh attributes of a cache group
10
Interfacing with TimesTen Replication
Viewing the replication scheme
Viewing the details of the TimesTen subscriber databases
Viewing the store attributes of the replicated TimesTen databases
Starting the replication agent
11
Working with TimesTen Performance Metrics
Creating snapshots
Dropping snapshots
Editing the TimesTen performance metrics configuration
Creating a TimesTen performance metrics report
Saving a report
12
TimesTen Reports
Generating TimesTen Reports
About Your Database
All Objects
Cache Groups
Database Administration
Performance
PLSQL
Security
Table
Index
Scripting on this page enhances content navigation, but does not change the content in any way.