Samir Roy, Author At DBA POSTMORTEM

Monitor Table Size Changes in Oracle: Powerful DBA Script

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

The ORA-02095 error occurs when you try to modify a static initialization parameter using the ALTER SYSTEM or ALTER SESSION

nohup means no hang-up. This command allows Linux processes to continue running in the background even after logging out or

As a DBA, we might need to provide details of sessions to Application Team. We can fetch the sid, sql_id