-
The Private AI Services Container: Vector Embeddings That Never Leave Your Network
Continue reading →: The Private AI Services Container: Vector Embeddings That Never Leave Your NetworkWho 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…
-
Aurora PostgreSQL 18 Upgrade Notes: B-Tree Skip Scans and What Actually Changed in Query Plans
Continue reading →: Aurora PostgreSQL 18 Upgrade Notes: B-Tree Skip Scans and What Actually Changed in Query PlansOur 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…
-
Select AI and Vector Search on a Legacy Oracle Schema: What It Actually Takes
Continue reading →: Select AI and Vector Search on a Legacy Oracle Schema: What It Actually TakesSelect 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.
-
Local HNSW Indexes in Oracle AI Database 26ai: Partitioned Vector Search Without the Global Graph Rebuild
Continue reading →: Local HNSW Indexes in Oracle AI Database 26ai: Partitioned Vector Search Without the Global Graph RebuildOracle AI Database 26ai’s April 2026 release update added local HNSW indexes: one vector graph per partition instead of one giant global graph. Here’s what that fixed for me, the CREATE INDEX syntax, and the gotchas the docs bury in…
-
DatabaseUnderstanding Oracle Database Background Processes and Their FunctionalityDatabase
Continue reading →: DatabaseUnderstanding Oracle Database Background Processes and Their FunctionalityDatabaseOracle Database is an advanced relational database management system (RDBMS) that utilizes multiple background processes to ensure efficient operation, transaction management, and system recovery.
-
Mastering the Art of Oracle Database Cloning Using RMAN
Continue reading →: Mastering the Art of Oracle Database Cloning Using RMANDatabase cloning is vital in modern management, allowing exact replicas of Oracle databases for testing and disaster recovery. This article explains the cloning process using the Recovery Manager (RMAN), detailing steps like backing up the source database, creating a new…
-
The Importance of Using AWS Key Management Service (KMS) Keys for Amazon RDS Databases
Continue reading →: The Importance of Using AWS Key Management Service (KMS) Keys for Amazon RDS DatabasesThe Importance of Using AWS Key Management Service (KMS) Keys for Amazon RDS Databases Introduction Amazon Web Services (AWS) provides a wide range of services to support businesses in managing their data and applications. Among these services, Amazon Relational Database…
-
Impacts of Overallocating Resources to Your Database and How to Keep Technical Debt Under Control
Continue reading →: Impacts of Overallocating Resources to Your Database and How to Keep Technical Debt Under ControlIntroduction A database is a vital component of any information system, serving as a repository for storing, managing, and retrieving data. As data demands increase, organizations often face the challenge of allocating adequate resources to their databases to ensure optimal…
-
Unleashing the Power of Oracle Database 23ai: A Deep Dive into AI Vector Search
Continue reading →: Unleashing the Power of Oracle Database 23ai: A Deep Dive into AI Vector SearchUnleashing the Power of Oracle Database 23ai: A Deep Dive into AI Vector Search Oracle Database continues to evolve, constantly pushing the boundaries of data management and analytics. The latest iteration, Oracle Database 23ai, introduces a wealth of innovative features…
-
Charting Your Course: How to Plan a Successful Database Migration to the Cloud
Continue reading →: Charting Your Course: How to Plan a Successful Database Migration to the CloudCharting Your Course: How to Plan a Successful Database Migration to the Cloud Migrating your database to the cloud can unlock significant benefits, including increased scalability, cost optimization, and enhanced security. However, a rushed or poorly planned migration can lead…
Oracle ACE Pro · AWS Community Builder
Arvind Toorpu
Oracle Certified Professional and Cloud Ops Database Manager at a financial services firm. Fourteen years architecting and running Oracle, SQL Server, PostgreSQL and MySQL estates, including migrations of hundreds of databases to AWS, Azure and OCI.
This blog is the tuning, recovery, security and migration work behind that — written up as it actually happened, errors included.
Oracle ACE Pro 2026 · AWS Community Builder 2026 · Oracle Certified Professional
Oracle · SQL Server · PostgreSQL · MySQL | AWS · Azure · OCI | Awards · Publications
Browse by topic
Oracle · Backup & Recovery · Administration & Maintenance · Security & Auditing · Cloud & Migration · Performance & Tuning · SQL Server · PostgreSQL & Aurora · All topics →
Latest writing
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.
