whichdb

Oracle TimesTen

active

by Oracle Corporation · since 1998 · also known as TimesTen, TimesTen In-Memory Database, TimesTen Scaleout

Oracle's in-memory relational database: microsecond SQL, PL/SQL, and a cache tier for Oracle Database.

relationaldatabase engineproprietarymature
Website Docs Compare Find similar

Overview

TimesTen is an in-memory relational database that keeps the full dataset in RAM while logging and checkpointing to disk, giving microsecond-level response times for SQL and PL/SQL. It comes in two shapes: Classic, often used as a read/write cache in front of Oracle Database (Cache for Oracle), and Scaleout, a shared-nothing distributed edition. It is common in telecom charging, trading and real-time fraud checks where Oracle-compatible SQL at memory speed matters. Oracle shipped a new major line, TimesTen 26.1, in April 2026 with support to 2034, while 22.1 is supported to 2030.

Transactional apps (OLTP)CachingReal-time analyticsFinancial tick data

Strengths & trade-offs

Strengths

  • +Microsecond SQL latency with the dataset held in RAM
  • +Oracle SQL, PL/SQL and OCI compatibility; apps can move between TimesTen and Oracle
  • +Cache for Oracle keeps hot tables in memory and syncs writes back
  • +Direct-linked mode runs the database inside the application process

Trade-offs

  • −Dataset must fit in RAM across the cluster
  • −Oracle licensing cost
  • −Smaller community; few third-party tools target it directly

Great for

  • +Telecom online charging and policy control
  • +Trading and market-data applications
  • +Real-time fraud and authorisation checks
  • +In-memory cache tier in front of Oracle Database

Think twice for

  • −Datasets much larger than available memory
  • −Cost-sensitive caching (Redis/Valkey are cheaper)
  • −Analytical workloads

Capabilities

Native or official first-party support · 9 of 25 tracked

✓Transactions
✓Joins
✓Secondary indexes
✓Stored procedures
✓Materialized views
✓In-memory
✓Durable persistence
✓Compression
✓Role-based access
–Full-text search
–Vector search
–Geospatial
–JSON
–Change data capture
–Triggers
–TTL / expiry
–Pub/Sub
–Columnar storage
–Encryption at rest
–Time travel
–Branching
–Online schema changes
–Streaming ingest
–Offline sync
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Medium · ≤ 10 TB
Horizontal scaling
Native
Multi-region
Read replicas
Transactions
Full ACID
Consistency
Strong
Schema
Strict
Architecture
In memory, Distributed, Primary replica, Embedded
Query languages
SQL, PL/SQL

Scaleout edition distributes data across nodes with K-safety replicas; Classic uses active-standby pairs.

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

Ecosystem

compatible withOracle
apis & protocolsOracle Call Interface (OCI), ODBC, JDBC, Pro*C
client languagesC, C++, Java, Python, JavaScript

Alternatives to Oracle TimesTen

Compare all→
RedisKey-Value84.3

The in-memory data structure server that became the default cache, now with search, JSON and vectors built in.

oracle-timesten vs redis →
SAP HANARelational39.7

SAP's in-memory columnar HTAP database, the mandatory engine under S/4HANA.

oracle-timesten vs sap-hana →
AltibaseRelational5.5

Korean hybrid in-memory/on-disk RDBMS for telecom and finance, closed-source again since 2023.

oracle-timesten vs altibase →
Volt Active Data (VoltDB)Relational20.7

In-memory, partitioned SQL engine running Java stored procedures serially for millisecond decisioning.

oracle-timesten vs volt-active-data →
Oracle DatabaseRelational56.9

The enterprise heavyweight: RAC, Data Guard and a converged engine for SQL, JSON, graph and vectors.

oracle-timesten vs oracle-database →
Apache IgniteKey-Value28.3

A distributed, memory-first SQL database and compute grid; Ignite 3 rebuilt it around Raft and Calcite.

oracle-timesten vs apache-ignite →

Oracle TimesTen FAQ

What is Oracle TimesTen?

Oracle TimesTen is a relational database by Oracle Corporation, first released in 1998. TimesTen is an in-memory relational database that keeps the full dataset in RAM while logging and checkpointing to disk, giving microsecond-level response times for SQL and PL/SQL. It comes in two shapes: Classic, often used as a read/write cache in front of Oracle Database (Cache for Oracle), and Scaleout, a shared-nothing distributed edition. It is common in telecom charging, trading and real-time fraud checks where Oracle-compatible SQL at memory speed matters. Oracle shipped a new major line, TimesTen 26.1, in April 2026 with support to 2034, while 22.1 is supported to 2030.

Is Oracle TimesTen open source?

No. Oracle TimesTen is proprietary, closed-source software.

Does Oracle TimesTen support ACID transactions?

Yes. Oracle TimesTen supports full ACID transactions, with strong consistency.

Does Oracle TimesTen scale horizontally?

Oracle TimesTen scales horizontally out of the box, with built-in sharding or partitioning. It is comfortable at medium scale (≤ 10 TB). It supports cross-region read replicas.

How can I run Oracle TimesTen?

You can self-host it and embed it in your application.

What is Oracle TimesTen best for?

Oracle TimesTen is a strong fit for telecom online charging and policy control; trading and market-data applications; and real-time fraud and authorisation checks. Think twice for datasets much larger than available memory.

What are the best alternatives to Oracle TimesTen?

Common alternatives to Oracle TimesTen include Redis, SAP HANA, Altibase, Volt Active Data (VoltDB) and Oracle Database. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

How popular is Oracle TimesTen?

Oracle TimesTen ranks #310 of 844 databases on the WhichDB Score (9.5/100), and #101 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.