How to Perform Stats Gather in Oracle Database :
Do you know why stats gather is required in Oracle Database? i)As a DBA we may see that, highly transactional tables often gets stale. So stats gather can improve its…
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 multiplexing in Oracle database. As a DBA, we may face…
Index Rebuild in Oracle Database :
Do you know why index rebuild is required in oracle? If the index gets invalid or unusable state for some reason, then we have to rebuild. Also, for frequently accessed…
Tablespace is Growing fast in Oracle Database :
Tablespace is a logical storage structure of a database that contains tables, indexes etc. So if a table, lob partition or index is growing high, then the corresponding tablespaces will…
Basic Commands in RAC:
As an experienced DBA, we must know the basic commands in RAC for Oracle DBA. So, today in this article, we will learn some basic commands in RAC (Oracle Database)…
What is granules in Oracle Database :
Granules in oracle refers to a unit of memory allocation used for managing the SGA (System Global Area) memory structure or we can say it is a unit of contiguous…
How to find the DDL of a user in Oracle Database:
Today in this article, we will learn how to get the DDL of a user in Oracle Database. This can be useful when migrating the database as well and we…
How to get the DDL of a Tablespace in Oracle :
To find the DDL (Data Definition Language) of a tablespace in Oracle Database, we can work the DBMS_METADATA package.A tablespace consists of one or more physical data files. DDL of…
How to find DDL of a table in Oracle Database :
Tables are an essential component that store data in a structured manner. At times, you may need to find the DDL of a table in Oracle database, which is a…
Enable-Disable Archivelog Mode in Oracle Database:
Here we will learn how to enable-disable archivelog mode in Oracle database. But why do we enable-disable archivelog mode in oracle database and why it is important? First of all,…