Samir Roy, Author At DBA POSTMORTEM

How to setup putty: Step-by-Step Guide

Putty is a popular tool to establish connections securely and efficiently from your machine (laptop/desktop) to the remote servers created […]

Oracle VirtualBox is a platform to run multiple operating systems on a single machine. If you have a Windows laptop,

Do you know how to troubleshoot high FRA usage in Oracle, if you are looking for the same, then you

change instance name in Oracle Database

In our operational daily basis DBA activities, it is important to know the schema size, table size, DB size, object

Do you know why stats gather is required in Oracle Database? i)As a DBA we may see that, highly transactional

Controlfile multiplexing means to create copy of multiple controlfiles. Today we will learn its importance and how to do Controlfile

Do you know why index rebuild is required in oracle? If the index gets invalid or unusable state for some

Tablespace is a logical storage structure of a database that contains tables, indexes etc. So if a table, lob partition