Introduction ORAchk (Oracle Autonomous Health Framework) is a utility provided by Oracle to perform proactive health checks and validation of Oracle databases, clusters, and Oracle hardware. It helps in identifying potential issues and recommends actions to improve performance, stability, and security. It’s a good idea to upload the AHF output as part of any support … Read more
What is Hidden Parameter in Oracle? Hidden parameters in Oracle Database, often referred to as “Underscore parameters,” are settings that do not appear in standard queries like SHOW PARAMETER or V$PARAMETER unless they have been explicitly set. These parameters usually begin with an underscore (“_”) and are also known as “Undocumented Parameters” because Oracle does … Read more
Introduction: Archiving Oracle databases facilitates long-term data retention and storage. However, if space becomes insufficient, it raises concerns about the continuity of data archiving processes. When the archive destination reaches its capacity, your Oracle Database may encounter issues such as hanging or becoming unresponsive, accompanied by error messages like the following: ORA-00257: Archiver Error, connect … Read more
After successfully installing Grid Infrastructure with the “grid” user, I attempted to install Oracle Database 19c Release 3 using the “oracle” user. However, during the installation process, I encountered an issue where none of my ASM (Automatic Storage Management) disks were visible in the disk group selection menu. Log in as root user Login as … Read more
In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of the three protection modes: Maximum Protection, Maximum Availability, or Maximum Performance. The steps to change the protection mode are straightforward but need to be done carefully to avoid any potential issues with your Data Guard setup. Primary database: Verify the … Read more
Hash partitioning is a database partitioning technique used in Oracle databases to distribute data evenly across multiple partitions. This method is particularly useful for ensuring a balanced distribution of data and for improving query performance by minimizing data retrieval times. In contrast to Range or List Partitioning, where you specify the criteria that determine the … Read more
What is Memory Tuning? Memory tuning involves redistributing or reallocating free memory to Oracle memory components, primarily aimed at optimizing the performance of Oracle queries. As database performance continues to be a significant concern for many clients, this blog delves into the intricacies of memory tuning within databases, highlighting its pivotal role in achieving high … Read more
As an Oracle DBA, there may be times when you need to terminate a session. For example, an application developer might accidentally run a resource-intensive query multiple times or face network issues during a large update operation. In such scenarios, they might ask the DBA to kill the session to avoid further impact on the … Read more
The ORA-16855 error indicates that the transport lag (the delay in sending redo data from the primary to the standby database) has exceeded the specified threshold. Cause: The current apply lag has exceeded the value specified by the ApplyLagThreshold configurable property. This can be due to either a significant transport lag or poor performance of … Read more
Hope it worked !! 🙂