Arvind Toorpu

Blog Posts

WAIT and NOWAIT: Giving Every DML Statement a Lock Timeout

August 8, 2026

Who this is for: anyone who has run a one-off UPDATE, gotten pulled away before committing it, and come back to find three other sessions queued up behind a lock nobody could tell how long to wait for. A teammate was fixing a bad row in production last summer, a quick UPDATE to correct a…
Small Oracle 23ai Syntax Wins That Saved Me Real Time

August 4, 2026

A spreadsheet seed job and a rounding check on the same Friday showed me how much small Oracle 23ai syntax has quietly improved. Here is what multi-row inserts and select without from actually save, and where they still need care.
The Private AI Services Container: Vector Embeddings That Never Leave Your Network

July 29, 2026

Who this is for: anyone whose security team has ever said “you can build semantic search, but nothing sensitive leaves this network to hit a third-party embeddings API,” and left you stuck doing keyword search instead. A healthcare client I worked with a while back wanted vector search over patient intake notes, the kind of…
Aurora PostgreSQL 18 Upgrade Notes: B-Tree Skip Scans and What Actually Changed in Query Plans

July 22, 2026

Our monthly reconciliation query was tripping a 300-second timeout because the planner couldn’t use a composite index without a tenant_id predicate. Aurora PostgreSQL 18’s B-tree skip scans fixed it without touching the query, and here are the actual before and after plans.
Select AI and Vector Search on a Legacy Oracle Schema: What It Actually Takes

July 16, 2026

Select AI and vector search work great on Oracle’s polished sample schemas. Production tables built over a decade tell a different story. Here’s what it actually took to get both working on ours, code included.

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts