Samir Roy, Author At DBA POSTMORTEM

How to Check MongoDB Size in GB: 4 Easy Steps

As a DBA when managing a MongoDB instance, monitoring database size is crucial for performance optimization and storage planning. This […]

As a Mongo DBA, we must learn how to use mongodump and mongorestore to back up MongoDB and restore the

Discover Hidden Parameters in Oracle with SQL queries to extract undocumented system settings. Learn how to identify non-default hidden parameters

This guide provides an SQL script to monitor table size changes in Oracle over the last N days, helping you

This article provides an SQL query to extract the DDL of User Privileges in Oracle, enabling efficient privilege management and

Tablespaces are essential storage structures for Oracle database objects. In this guide, we will provide a simple SQL script to

Redo log files are crucial for Oracle database recovery and transaction management. It stores all the changes made to the

MongoDB is a popular NoSQL database that offers flexible and scalable data management. To enhance security, it is essential to

MongoDB is a popular NoSQL database that provides a flexible and scalable way to manage data. If you’re a beginner