Samir Roy, Author At DBA POSTMORTEM

How to increase number of process in oracle : 3 EASY STeps

In our article, we have already discussed the ORA-00020: maximum number of processes exceeded error. So, today we will discuss […]

Stop Oracle RAC Database operations must be done carefully to keep it highly available and protect your data. Oracle offers

Start Oracle RAC Database operations should be done using Oracle’s srvctl utility to ensure consistent, cluster-aware startup procedures across all

In our previous article, we have learnt how to create index in MongoDB. Now, as a mongo DBA if you’re

Index in MongoDB has a significant role to improve query performance by allowing efficient data retrieval. If the index is

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