Deep Dive

Key Differences Between Oracle 19c and 23ai

A detailed side-by-side comparison of Oracle Database 19c and 23ai across AI capabilities, SQL and PL/SQL, security, performance, architecture, developer experience, and support lifecycle — to help you decide when and whether to upgrade.

Oracle 23ai Help Team March 21, 2025 14 min
Deep Dive

Oracle 23ai New Features: Everything You Need to Know

A comprehensive overview of Oracle Database 23ai's 300+ new features — from AI Vector Search and JSON Duality Views to SQL Firewall, Schema Privileges, True Cache, Property Graph, and developer quality-of-life improvements.

Oracle 23ai Help Team March 20, 2025 16 min
Deep Dive

Oracle 23ai: Everything You Need to Know About the VECTOR Data Type

The VECTOR data type is Oracle's most significant new primitive in over a decade. We cover its internals, index types, quantization options, and real-world performance benchmarks.

Maria Chen March 14, 2025 12 min
Tutorial

JSON Relational Duality Views: Bridging Relational and Document Worlds

Oracle 23ai's JSON Duality Views let you work with relational data as JSON documents — and back again — without duplication, without syncing, and without compromise.

Oracle 23ai Help Team February 28, 2025 9 min
Performance

Benchmarking HNSW vs IVF Vector Indexes in Oracle 23ai

A deep dive into Oracle 23ai's two vector index types — HNSW and IVF — covering how each works, when to use them, tuning parameters, memory sizing, and real-world performance guidance.

Oracle 23ai Help Team February 20, 2025 15 min
DevOps

Running Oracle 23ai in Docker: A Production-Ready Setup

Everything you need to run Oracle Database 23ai in Docker from choosing the right image to persistent storage, Docker Compose, health checks, networking, backups, and connecting your application.

Oracle 23ai Help Team February 12, 2025 14 min
Security

Schema Privileges: The End of GRANT-ALL Anti-Patterns

Oracle 23ai introduces schema-level privileges — a long-awaited middle tier between granting access to a single object and granting access to everything. Here's why it matters, how it works, and how to migrate away from the GRANT ANY anti-pattern.

Oracle 23ai Help Team January 31, 2025 10 min
Migration

Upgrading from Oracle 19c to 23ai: Lessons Learned

A practical guide to upgrading Oracle Database 19c to 23ai — covering upgrade paths, AutoUpgrade tool walkthrough, pre-upgrade checks, non-CDB to CDB migration, common blockers, and post-upgrade validation.

Oracle 23ai Help Team January 18, 2025 18 min