Category: post

Oracle database cleanup process after DROP DATABASE command - complete removal checklist

Complete Oracle Database Cleanup Checklist: Remove CDB After DROP DATABASE

Posted on by sanjeeva

Two weeks ago, I dropped a development CDB called TESTCDB on one of our lab servers. The DROP DATABASE command worked perfectly—but that was just the beginning. The server was still littered with configuration files, diagnostic logs, and startup scripts pointing to a database that no longer existed. If you’ve ever run DROP DATABASE INCLUDING Read more about Complete Oracle Database Cleanup Checklist: Remove CDB After DROP DATABASE[…]

Oracle CDB architecture showing pluggable database DATAPDB being dropped with datafiles - Oracle 19c multitenant illustration

How to Drop a Pluggable Database Including Datafiles in Oracle 19c

Posted on by sanjeeva

Last month, I needed to decommission a development PDB that was consuming valuable storage on our production CDB. The challenge? Ensuring all datafiles were completely removed without affecting other PDBs in the container. If you’ve ever hesitated before dropping a PDB—worried about orphaned datafiles or accidentally keeping files you meant to delete—this guide walks you Read more about How to Drop a Pluggable Database Including Datafiles in Oracle 19c[…]

Architecture comparison showing complex specialized vector database setup versus simple PostgreSQL pgvector unified solution for AI workloads

Why PostgreSQL Beat Specialized Vector Databases: A DBA’s Perspective

Posted on by sanjeeva

Last Updated: December 2025 | By Sanjeeva Kumar | 20+ Years in Database Systems The Plot Twist Nobody Saw Coming Two weeks ago, PostgreSQL’s pgvector extension released version 0.8.0. Within days, the entire vector database market collectively held its breath. Why? Because that “old guard” relational database just made billion-dollar vector database startups look like Read more about Why PostgreSQL Beat Specialized Vector Databases: A DBA’s Perspective[…]

Migrating Oracle 19c Database from Local Storage to ASM: A Complete Step-by-Step Guide

Posted on by sanjeeva

Last Updated: December 2025 | Oracle 19c | ASM Grid Infrastructure Have you ever encountered a frustrating situation where your Oracle database is running on local storage, and you need to migrate everything to ASM (Automatic Storage Management) without significant downtime? Recently, we faced this exact scenario with a production Oracle 19c Container Database (CDB) Read more about Migrating Oracle 19c Database from Local Storage to ASM: A Complete Step-by-Step Guide[…]

From Regulation to Responsibility: Understanding the EU’s AI regulation

Posted on by sanjeeva

Introduction Artificial Intelligence (AI) has rapidly transformed various aspects of our lives, from personalized recommendations to autonomous vehicles. However, with great power comes great responsibility. The European Union (EU) recognizes the need to strike a balance between fostering AI innovation and safeguarding fundamental rights. On March 13, 2024, the EU took a significant and bold step Read more about From Regulation to Responsibility: Understanding the EU’s AI regulation[…]