1/14

Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 11.2.2.7.0
• New features in Release 11.2.2.5.0
• New features in Release 11.2.2.4.0
• New features in Release 11.2.2.2.0
• New features in Release 11.2.2.1.0
• New features in Release 11.2.2.0.0

1 Oracle TimesTen In-Memory Database and TimesTen Application-Tier Database Cache

• Why is Oracle TimesTen In-Memory Database fast?
• TimesTen and TimesTen Cache feature overview
  • TimesTen API support
    • ODBC and JDBC interfaces
    • SQL and PL/SQL functionality
    • OCI and Pro*C/C++ Precompiler support
    • ODP.NET support
    • Transaction Log API
    • TTClasses
    • Distributed Transaction Processing APIs
  • Access Control
  • Database connectivity
  • Durability
  • Performance through query optimization
  • Concurrency
  • Database character sets and globalization support
  • In-memory columnar compression
  • Data replication between servers
  • Cached data with the TimesTen Cache
  • Load data from an Oracle database into a TimesTen table
  • Business intelligence and online analytical processing
  • Large objects
  • Automatic data aging
  • System monitoring
  • Administration and utilities

2 Using TimesTen and TimesTen Cache

• Uses for TimesTen
• Uses for TimesTen Cache
• TimesTen application scenario
  • Real-time quote service application
• TimesTen Cache application scenarios
  • Call center application
  • Caller usage metering application

3 TimesTen Cache Architecture and Components

• Architectural overview
• Shared libraries
• Memory-resident data structures
• Database processes
• Administrative programs
• Checkpoint and transaction log files
• Cached data
• Replication
• TimesTen connection options
  • Direct driver connection
  • Client/server connection
  • Driver manager connection
• For more information

4 Concurrent Operations

• Transaction isolation
  • Read committed isolation
  • Serializable isolation
• Locking levels
  • Database-level locking
  • Table-level locking
  • Row-level locking
• For more information

5 Query Optimization

• Optimization time and memory usage
• Statistics
• Optimizer hints
• Indexes
• Scan methods
• Join methods
  • Nested loop join
  • Merge join
• Optimizer plan
• For more information

6 Data Availability and Integrity

• Transaction logging
  • Writing the log buffer to disk
  • When are transaction log files deleted?
  • TimesTen commits
• Checkpointing
  • Nonblocking checkpoints
  • Blocking checkpoints
  • Recovery from log and checkpoint files
• Replication
  • Active standby pair
  • Classic replication configurations
    • Unidirectional replication
    • Bidirectional replication
  • Asynchronous and return service replication
  • Replication failover and recovery
  • Automatic client failover for active standby pair replication
• For more information

7 Event Notification

• Detect transaction modifications with the Transaction Log API
  • How XLA works
  • Log update records
• Monitor tables with materialized views and XLA
• Monitor problems with SNMP traps
• For more information

8 TimesTen Cache

• Cache groups
• Dynamic cache groups and explicitly loaded cache groups
• Global and local cache groups
• Cache grid
• Transmitting data between the TimesTen Cache and an Oracle database
  • Updating a cache group from the Oracle database tables
  • Updating the Oracle database tables from a cache group
• Aging feature
• Passthrough feature
• Replicating cache groups
• Using the Cache Advisor
• For more information

9 TimesTen and TimesTen Cache Administration

• Installing TimesTen and TimesTen Cache
• Access Control
• Command line administration
• SQL administration
• SQL Developer
• ODBC Administrator
• Upgrading TimesTen and the TimesTen Cache
  • In-place upgrades
  • Offline upgrades
  • Online upgrades
• For more information

Index