Step-by-Step Guide: How to Download and Install Oracle VirtualBox
Oracle VirtualBox is a platform to run multiple operating systems on a single machine. If you have a Windows laptop, there's a general dilemma: you may want to install the…
Oracle VirtualBox is a platform to run multiple operating systems on a single machine. If you have a Windows laptop, there's a general dilemma: you may want to install the…
Do you know how to troubleshoot high FRA usage in Oracle, if you are looking for the same, then you are at the right place. FRA stands for fast recovery…
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 size etc. So here are the proper steps/commands where you…
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 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…
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 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…
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)…
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…