1/14

Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 18.1.3.1.0
• New features in Release 18.1.1.1.0

1 Overview for the Oracle TimesTen In-Memory Database

• TimesTen database performance overview
• TimesTen In-Memory Database general feature overview
  • TimesTen API and language support
    • SQL and PL/SQL functionality
    • OCI, ODBC and JDBC interfaces
    • Pro*C/C++ Precompiler support
    • ODP.NET support
    • Open source programming languages
    • TTClasses
  • Transactional ACID compliance
  • Durability
    • Durability for TimesTen Classic
    • Durability for TimesTen Scaleout
  • Performance through query optimization
  • Concurrency
  • Database character sets and globalization support
  • Database connectivity
  • Load data from an Oracle database into a TimesTen table
  • System monitoring
    • System monitoring through system tables and views
    • System monitoring for TimesTen Classic
    • System monitoring for TimesTen Scaleout
  • Administration and utilities
• TimesTen Scaleout specific features
  • High availability features for TimesTen Scaleout
  • Transparent data distribution
  • Online elastic scalability
  • Automatic high availability through K-Safety
  • Single point for administration and monitoring
• TimesTen Classic specific features
  • High availability features for TimesTen Classic
  • Data replication between servers
  • Transaction Log API (XLA)
  • Automatic data aging
• TimesTen Cache specific features

2 Using TimesTen

• Uses for TimesTen Scaleout
  • TimesTen Scaleout application scenario
• Uses for TimesTen Classic
  • TimesTen Classic application scenario
• Uses for TimesTen Cache
  • TimesTen Cache application scenario

3 TimesTen Architecture

• Architectural overview
  • Architectural overview of TimesTen Classic and TimesTen Cache
  • Architectural overview of TimesTen Scaleout
• Shared libraries
• Memory-resident data structures
• Database processes
  • TimesTen daemon
  • Subdaemons
• TimesTen connection options
  • Direct connection
  • Client/server connection
  • Driver manager connection
• Checkpoint and transaction log files
• Cached data
• Replication

4 Concurrent Operations

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

5 Query Optimization

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

6 Data Availability and Integrity

• Transaction logging
  • Writing the transaction log buffer to disk
  • When are transaction log files deleted?
  • TimesTen commits
• Checkpointing
  • Nonblocking checkpoints
  • Blocking checkpoints
  • Recovery from the transaction log and checkpoint files
• Data Replication within TimesTen Classic
  • 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

7 TimesTen Cache

• Cache groups
• Dynamic cache groups and explicitly loaded cache groups
• 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
• Disaster recovery through TimesTen Cache

8 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

9 TimesTen Administration

• Installing TimesTen
• Access control
• Command line administration
• SQL administration
• SQL Developer
  • Facilitating TimesTen Scaleout development and management
  • Facilitating TimesTen Classic development and management
• ODBC Administrator
• Migrating a database
• Upgrading TimesTen
  • Upgrades for a grid in TimesTen Scaleout
  • Offline upgrades for TimesTen Classic
  • Online upgrades for TimesTen Classic

Index