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