Arvind Toorpu

Blog Posts

Local HNSW Indexes in Oracle AI Database 26ai: Partitioned Vector Search Without the Global Graph Rebuild

July 8, 2026

Oracle 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 the usage notes.
DatabaseUnderstanding Oracle Database Background Processes and Their FunctionalityDatabase

July 5, 2026

Oracle 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

August 14, 2025

Database 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 one, and applying configurations. It emphasizes prerequisites, technical requirements, and best practices. Ultimately, RMAN cloning…
The Importance of Using AWS Key Management Service (KMS) Keys for Amazon RDS Databases

July 30, 2025

The 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 Service (RDS) is a popular choice for organizations looking to set up, operate, and scale…
Impacts of Overallocating Resources to Your Database and How to Keep Technical Debt Under Control

July 3, 2025

Introduction 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 performance. However, overallocating resources to a database can have significant impacts on system performance, cost,…

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.

Arvind Toorpu

Blog Posts

Local HNSW Indexes in Oracle AI Database 26ai: Partitioned Vector Search Without the Global Graph Rebuild

DatabaseUnderstanding Oracle Database Background Processes and Their FunctionalityDatabase

Arvind Toorpu

Let’s connect

Join the fun!

Recent posts

Fixing Replication Lag with Parallel Logical Replication in Aurora PostgreSQL

SQL Server 2025 Intelligent Query Processing: What Changed at Compatibility Level 170

Priority Transactions: Letting the Database Roll Back Its Own Blockers in Oracle AI Database 26ai

Automatic Transaction Quarantine in Oracle AI Database 26ai: When One Bad Transaction Won’t Take Down the Whole Database

Oracle AI Database 26ai Is a Patch, Not an Upgrade: Reading the New Version Numbers

WAIT and NOWAIT: Giving Every DML Statement a Lock Timeout

Blog Posts

Share this:

Arvind Toorpu

Let’s connect

Join the fun!

Recent posts