Tag: tag

Production DBA checklist diagram for Oracle AI Database 26ai deployment covering vector infrastructure sizing, JSON Relational Duality deployment gates, and Select AI governance decisions

Building an AI-Ready Oracle Database: A Production DBA Checklist

Posted on by Sanjeeva Kumar

Three weeks before go-live on an Oracle AI Database 26ai deployment, we ran a readiness review mostly with the help of Oracle AI Database 26ai production DBA checklist. At the surface level, things looked stable. Vector search was working in staging. JSON Relational Duality Views were serving the REST layer. Select AI was configured against Read more about Building an AI-Ready Oracle Database: A Production DBA Checklist[…]

Architecture diagram showing Oracle AI Database 26ai Select AI flow — natural language input, schema metadata sent to external LLM, generated SQL returned and executed against relational tables

Select AI: Talking to Your Database in Plain English

Posted on by Sanjeeva Kumar

A developer on our team sent a message last week: “Is there a way to just ask the database how many Critical errors are in the Memory category without writing SQL?” He had heard about Oracle Select AI 26ai and wanted to know if it was live on our instance. That question is exactly the Read more about Select AI: Talking to Your Database in Plain English[…]

Architecture diagram showing how Oracle AI Database 26ai JSON Relational Duality Views translate JSON writes into row-level DML on underlying relational tables, with lock icons indicating concurrent access behavior.

5 Things DBAs Must Know About JSON Relational Duality in Oracle AI Database 26ai

Posted on by Sanjeeva Kumar

Last month we were reviewing a staging incident where an application team had migrated their REST layer to use JSON Relational Duality Views in Oracle AI Database 26ai. The feature worked exactly as advertised during unit testing — clean JSON in, clean JSON out, relational tables staying normalized underneath. Then they ran a load test Read more about 5 Things DBAs Must Know About JSON Relational Duality in Oracle AI Database 26ai[…]

Oracle AI Database 26ai in-database ONNX embedding model compared to pgvector external API embedding architecture — data sovereignty and latency comparison

Oracle AI Database 26ai Vector Search vs PostgreSQL pgvector — A DBA’s Perspective

Posted on by Sanjeeva Kumar

We have run vector search workloads on both Oracle AI Database 26ai and PostgreSQL with pgvector and we are here to show you the architectural breakdown of Oracle AI Database 26ai vector search vs pgvector. The technical capabilities of both are real — pgvector works, and PostgreSQL shops have built production vector search on it. Read more about Oracle AI Database 26ai Vector Search vs PostgreSQL pgvector — A DBA’s Perspective[…]

Oracle AI Database 26ai hybrid search combining VECTOR_DISTANCE semantic similarity with SQL WHERE filters in a single execution plan — no separate round trip required

Hybrid Search in Oracle AI Database 26ai — Combining SQL and Semantic Queries

Posted on by Sanjeeva Kumar

We had a support tool prototype running vector search against an Oracle error knowledge base. Pure semantic search — query comes in, top five similar errors come back. Worked well in testing. In production, the first complaint arrived within a week: “It keeps returning memory errors when I search for connection problems — they are Read more about Hybrid Search in Oracle AI Database 26ai — Combining SQL and Semantic Queries[…]