Oracle Administration Archives - Page 18 Of 19

How to change instance name in Oracle Database:

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

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