An Oracle vs CockroachDB comparison is essential reading for any organisation paying for RAC, Active Data Guard, GoldenGate, and the Partitioning option simultaneously. CockroachDB is a distributed SQL database with PostgreSQL wire-compatibility, native multi-region survivability, and a commercial model that does not charge for high availability as a separate option. The 5-year TCO gap to Oracle Database EE plus RAC plus Active Data Guard lands at 60 to 78 percent for genuinely distributed workloads. This is a buyer-side breakdown of where it wins, where it does not, and how Oracle's account team will challenge the move.
CockroachDB is a distributed SQL database designed for global OLTP workloads. It is PostgreSQL wire-compatible, supports serialisable isolation by default, and is built around the concept of distributed range-replicated data with automatic rebalancing. The architectural lineage is Google's Spanner paper, adapted to commodity infrastructure.
For Oracle estates, CockroachDB is the most credible like-for-like alternative to Oracle Database EE plus RAC plus Active Data Guard. RAC delivers active-active inside a single shared-storage cluster; ADG delivers cross-site disaster recovery; CockroachDB delivers both natively without separately-licensed options. For globally distributed workloads — financial services trading systems with operational presence in multiple regions, retail platforms with regional latency requirements, telecoms with active-active national-grid requirements — CockroachDB frequently outperforms RAC because RAC was never architected for cross-region operation.
What CockroachDB replaces in an Oracle estate: Database EE, the RAC option, Active Data Guard, GoldenGate for replication, and a meaningful portion of Partitioning option usage. It is the wrong destination for analytics-heavy workloads (Snowflake or Databricks) and for document-shaped workloads (MongoDB).
Three architectural features decide most RAC-replacement comparisons:
The implication for buyer-side TCO: features that Oracle bundles into separately-licensed RAC and Active Data Guard options — at $23,000 per core list each, on top of the base EE licence — are CockroachDB defaults.
| Path | Model | When to use |
|---|---|---|
| CockroachDB Core | BSL community | Dev / pre-production. Lacks multi-region, change feeds, audit logging, advanced auth. BSL converts to Apache 2.0 after 3 years per release. |
| CockroachDB Enterprise (self-managed) | Paid licence + support | On-premise production. Includes multi-region capabilities, change feeds, role-based access control, audit logging, enterprise backup & restore. Priced per vCPU, typically annually. |
| CockroachDB Cloud Dedicated | Per vCPU-hour + storage + RU | Production. Single-tenant cluster on AWS, Azure, or GCP. Customer chooses cloud provider, region, multi-region survival goal. |
| CockroachDB Cloud Standard | Per RU + storage | Multi-tenant managed service. Pay per Request Unit. Suits steady moderate workloads where dedicated capacity overhead is hard to justify. |
| CockroachDB Cloud Basic | Free tier / low usage | Dev and pre-production. Per-RU charges above a generous free monthly allowance. |
Most enterprise customers run Cloud Dedicated for production. Self-managed Enterprise is the path for regulated estates that cannot use a managed cloud service. Negotiated multi-year commits on Cloud Dedicated typically reduce 20 to 35 percent against on-demand.
| Component | Cloud Dedicated (AWS us-east-1) | Notes |
|---|---|---|
| vCPU compute | $0.45 / vCPU-hour (on-demand) | 1-year commit ~22% off; 3-year commit ~38% off |
| Memory | Included in vCPU price | Standard 4 GB / vCPU; high-memory shapes available |
| Storage | $0.25 / GB-month (provisioned) | Auto-extends; IOPS scaled with capacity |
| Backup storage | $0.045 / GB-month | Continuous, granular point-in-time recovery |
| Multi-region | Linear per additional region | Add survivability without licence uplift — region cost only |
| Request Units (Standard tier) | $0.85 / 1M RUs | Use for steady moderate workloads |
| Data transfer | Cloud-provider egress rates | Intra-region typically free |
The single largest TCO variable is right-sizing. We routinely see CockroachDB Cloud Dedicated estates running 20 to 35 percent over necessary because the cluster was sized for projected peak rather than measured peak. A buyer-side capacity review before the next renewal usually pays back the engagement within the first quarter.
| Capability | Oracle EE + RAC + ADG | CockroachDB Cloud Dedicated |
|---|---|---|
| Active-active multi-node | RAC (option licensed) | Native, all editions |
| Multi-region survival | ADG far sync (option licensed) | Native multi-region clusters |
| Automatic failover | ADG fast-start failover | Sub-second, Raft-based, no orchestration |
| Horizontal scale-out | RAC interconnect-bound | Linear scale-out, add nodes online |
| Default isolation | Read committed | Serialisable (stricter) |
| Wire compatibility | Oracle Net | PostgreSQL wire protocol |
| SQL syntax | Mature, Oracle-specific | PostgreSQL-compatible with extensions |
| PL/SQL | Mature | Limited stored procedures; UDFs in SQL |
| Partitioning | Partitioning option licensed | Native row-level partitioning + locality |
| Encryption at rest | Advanced Security (option licensed) | Built-in, KMS integrations |
| Change feeds | GoldenGate (separately licensed) | Native change data capture |
| Time travel / AS OF | Flashback Database (EE) | AS OF SYSTEM TIME (default 25 hr retention) |
Three performance characteristics dominate Oracle-to-CockroachDB comparisons:
The trade-off: single-row latency on small operations is higher than well-tuned Oracle on Exadata. For workloads that benchmark single-statement latency in sub-millisecond territory, Oracle still wins. For workloads that benchmark steady-state throughput, consistency, and survivability, CockroachDB wins decisively.
Scenario: 96-core Oracle Database EE workload with the RAC option, Active Data Guard, Partitioning, Advanced Compression, Advanced Security, and Diagnostics Pack. Three-region multi-master deployment serving a global trading platform. Annual run-rate: $4.3M including support.
| Cost component | Oracle EE + RAC + ADG | CockroachDB Cloud Dedicated |
|---|---|---|
| EE licence amortisation (5 yrs) | $2.28M | $0 |
| RAC option amortisation (5 yrs) | $2.21M | $0 |
| ADG option amortisation (5 yrs) | $2.21M | $0 |
| Other options amortisation (5 yrs) | $1.82M | $0 |
| Annual support (5 yrs) | $9.42M | Bundled in usage |
| CockroachDB compute (3-yr commit, 5 yrs) | $0 | $2.85M |
| Storage + backup (5 yrs) | Hardware | $0.42M |
| Multi-region cluster overhead (5 yrs) | Included | $0.48M |
| Migration project (Year 0) | $0 | $1.95M (one-off) |
| Operational delta (5 yrs) | baseline | -$1.20M (no RAC ops, no DG ops) |
| 5-year TCO | $17.94M | $4.50M |
The 75 percent saving across five years is at the upper end of what we see, driven primarily by elimination of the RAC and ADG options. For Oracle estates that are not licensed for RAC plus ADG, the saving narrows to 50 to 60 percent against base EE — still material but less dramatic.
Oracle-to-CockroachDB migrations are PostgreSQL-pattern migrations with multi-region wrinkles. Four components:
Schema and SQL. CockroachDB's PostgreSQL compatibility means most Oracle-to-Postgres patterns apply. Tools such as the AWS Schema Conversion Tool, ora2pg, and CockroachDB's own MOLT toolkit auto-convert 70 to 85 percent of typical schemas. Remaining manual remediation covers NUMBER precision, DATE semantics, identity columns, MERGE syntax, and Oracle-specific functions.
PL/SQL. The genuine work, as with any Oracle exit. CockroachDB has limited stored-procedure support relative to Oracle PL/SQL. The pattern is to lift PL/SQL business logic into application services rather than transliterate. SCT-style tooling auto-converts 30 to 50 percent; the rest is manual.
Multi-region design. Where CockroachDB earns its place. Regional table pinning, multi-region survival goals, and follower reads are first-class concepts that need to be designed into the schema. Migrations that ignore this design layer produce CockroachDB clusters that look like single-region Postgres — leaving the multi-region upside on the table.
Application changes. PostgreSQL wire compatibility means most JDBC / .NET / Python drivers work without code changes. The application-level changes are around handling serialisable retry errors gracefully — a one-time engineering investment in retry helpers.
Realistic timeline for a 96-core multi-region Oracle estate: 14 to 22 months end-to-end. Migration cost typically $1.6M to $2.8M depending on PL/SQL volume.
Cancelling RAC, Active Data Guard, and Oracle Database EE support all trigger LMS engagement letters with predictable regularity. Three vectors:
With buyer-side preparation — Effective Licence Position, virtualisation evidence, options usage history filed before the cancellation goes out — outcomes typically settle between 18 and 30 percent of Oracle's opening claim. Without preparation, opening claims of $5M to $25M for mid-market estates are routine.
Three scenarios where CockroachDB is the wrong destination:
For genuinely distributed, multi-region OLTP estates with strong consistency requirements — financial services trading platforms, global retail platforms, telecom subscriber estates — CockroachDB is the strongest like-for-like Oracle Database EE plus RAC plus Active Data Guard replacement on the market.
A global payments processor ran 80 Processor licences of Oracle Database EE with the RAC option, Active Data Guard, Partitioning, Advanced Security, Advanced Compression, and Diagnostics Pack in an active-active-active three-region deployment for transaction authorisation. Annual Oracle run-rate was $4.1M. The 18-month migration to CockroachDB Cloud Dedicated across three AWS regions delivered comparable transaction throughput at lower p99 latency for cross-region scenarios. CockroachDB annual run-rate at steady state with 3-year commit: $710K. An LMS engagement letter arrived 64 days after the non-renewal notice; the buyer-side audit defence pack — Effective Licence Position, RAC node inventory, ADG configuration history — held firm. Settlement landed at 19 percent of the opening claim. Net annual saving from Year 2: $3.4M. The customer subsequently migrated remaining single-region Oracle Database EE OLTP workloads to Aurora Postgres.
CockroachDB is a distributed SQL database with horizontal scale, multi-region survivability, and PostgreSQL wire-compatibility. It is designed for global OLTP workloads that historically required Oracle RAC plus Active Data Guard plus extensive operational engineering. Data is automatically replicated and rebalanced across nodes; transactions are serialisable by default; survivability can be set at zone, region, or multi-region levels.
Three commercial paths: CockroachDB Core (BSL community), CockroachDB Enterprise (paid licence with multi-region, change feeds, advanced auth, support), and CockroachDB Cloud (managed service in Dedicated, Standard, and Basic tiers on AWS, Azure, and GCP). Cloud Dedicated is priced per vCPU-hour plus storage and request units; Standard and Basic are usage-based.
For most RAC use cases, yes. CockroachDB delivers active-active multi-node operation, automatic failover, and survivability guarantees that exceed RAC for multi-region scenarios. Its consistency model (serialisable) is stricter than RAC's read-committed default. The exception is workloads tightly coupled to RAC-specific features (cache fusion semantics, single-instance latency optimisations).
Yes. Non-renewal of Oracle Database EE plus RAC plus Active Data Guard support triggers an LMS engagement letter predictably. Audit vectors are virtualisation compliance, options usage history including RAC option specifically, NUP under-counting, and Java SE Universal Subscription. See our Oracle audit defence guide.
For a mid-sized multi-region Oracle estate with RAC and ADG: 14 to 22 months end-to-end. PL/SQL is the longest workstream and is typically lifted into application services rather than transliterated. Multi-region design — survival goals, regional pinning, follower reads — needs to be engineered, not lifted-and-shifted.
Oracle's counter-positioning is Globally Distributed Autonomous Database on OCI, or RAC plus ADG plus GoldenGate as a stack. Globally Distributed ADB is technically interesting but priced on the same Oracle commercial model — Universal Credits with options stacking. Benchmark every counter-offer against the CockroachDB 5-year TCO. Counter-offer dynamics are covered in the Oracle negotiation guide.
Independence statement: Oracle Licensing Experts is an independent buyer-side advisory firm. Not affiliated with Oracle Corporation. We have no commercial relationship with Cockroach Labs. All numbers above reflect published pricing and benchmark engagement data.
Audit alerts, contract tactics, TCO benchmarks, and cloud migration intel — every two weeks. Read by ITAM leads, CIOs, and legal teams.
No spam. Unsubscribe anytime. Not affiliated with Oracle Corporation.