ORAchk (Oracle Autonomous Health Framework)
Introduction ORAchk (Oracle Autonomous Health Framework) is a utility provided by Oracle to perform proactive…
Read moreOracle
Hidden or Underscore Parameter in Oracle 19c
What is Hidden Parameter in Oracle? Hidden parameters in Oracle Database, often referred to as…
Read moreSecondary archive destinations in Oracle
Introduction: Archiving Oracle databases facilitates long-term data retention and storage. However, if space becomes insufficient,…
Read moreINS-30502 No ASM Disk Group Found.
After successfully installing Grid Infrastructure with the “grid” user, I attempted to install Oracle Database…
Read moreChanging Protection Mode in Data Guard !!
In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of…
Read moreHash partitioning in Oracle !!
Hash partitioning is a database partitioning technique used in Oracle databases to distribute data evenly…
Read moreMemory Tuning in Oracle Database
What is Memory Tuning? Memory tuning involves redistributing or reallocating free memory to Oracle memory…
Read moreHow to Kill Session in Oracle 19c
As an Oracle DBA, there may be times when you need to terminate a session.…
Read moreORA-16855: Transport Lag Has Exceeded Specified Threshold in Data Guard !!
The ORA-16855 error indicates that the transport lag (the delay in sending redo data from…
Read moreBasic Administration 12c/19c – Imp!!
Hope it worked !! 🙂
Read moreDataguard Configuration with DG Broker using Active Duplicate in Oracle !!
Hope it helped !! 🙂
Read moreHow To Purge The UNIFIED AUDIT TRAIL ?
Oracle Database – Enterprise Edition – Version 12.1.0.1 and later The unified audit trail can…
Read morePatching !!
In which months oracle release CPU patches? JAN, APR, JUL, OCT When we applying single…
Read moreSQL Developer
SQL Developer is a convenient way for database developers to edit and develop basic tasks…
Read moreParameter Files in Oracle
To start a database instance, Oracle Database must read either a server parameter file, which…
Read moreRunning nohup commands
The nohup command runs the command specified by the Command parameter and any related Arg…
Read moreSplit Brain Syndrome in RAC
Where two or more instances attempt to control a cluster database. Each node in this…
Read moreAbout Oracle Database Release Numbers
Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release,…
Read moreHow INSERT Statement get executed in Oracle??
1. As a laymen, consider a user/application requests a connection request to the Oracle database…
Read moreWhat Are Root.sh And OrainstRoot.sh Scripts ?
The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored…
Read moreVoting Disk in Oracle RAC
Voting disks manage information about node membership. Each voting disk must be accessible by all…
Read moreOracle Local Registry (OLR) in RAC
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry…
Read moreOracle Wait Events : ” enq: TM – Contention “
Enqueues are locks that coordinate access to database resources. This event indicates that the session…
Read moreOracle Wait Event : ” db_file_scattered_read “
This wait indicates that we are waiting for a read operation which reads a number…
Read moreOracle Wait Events : ” db_file_sequential_reads “
This event signifies that the user process is reading a buffer into the SGA buffer…
Read more