Samir Roy, Author At DBA POSTMORTEM

Controlfile Multiplexing in Oracle Database

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

As an experienced DBA, we must know the basic commands in RAC for Oracle DBA. So, today in this article,

Granules in oracle refers to a unit of memory allocation used for managing the SGA (System Global Area) memory structure

Today in this article, we will learn how to get the DDL of a user in Oracle Database. This can

To find the DDL (Data Definition Language) of a tablespace in Oracle Database, we can work the DBMS_METADATA package.A tablespace

Tables are an essential component that store data in a structured manner. At times, you may need to find the

Here we will learn how to enable-disable archivelog mode in Oracle database. But why do we enable-disable archivelog mode in