2 min read
What is Hidden Parameter in Oracle? Hidden parameters in Oracle Database, often referred to as "Underscore parameters," are settings that...
Oracle
2 min read
5 min read
Introduction: Archiving Oracle databases facilitates long-term data retention and storage. However, if space becomes insufficient, it raises concerns about the...
1 min read
After successfully installing Grid Infrastructure with the "grid" user, I attempted to install Oracle Database 19c Release 3 using the...
3 min read
In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of the three protection modes: Maximum...
3 min read
Hash partitioning is a database partitioning technique used in Oracle databases to distribute data evenly across multiple partitions. This method...
4 min read
What is Memory Tuning? Memory tuning involves redistributing or reallocating free memory to Oracle memory components, primarily aimed at optimizing...
1 min read
As an Oracle DBA, there may be times when you need to terminate a session. For example, an application developer...
2 min read
The ORA-16855 error indicates that the transport lag (the delay in sending redo data from the primary to the standby...
1 min read
1 min read
Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
2 min read
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later The unified audit trail can be purged using the DBMS_AUDIT_MGMT...
7 min read
In which months oracle release CPU patches? JAN, APR, JUL, OCT When we applying single Patch, can you use opatch...
SQL Developer is a convenient way for database developers to edit and develop basic tasks using SQL*Plus. SQL Developer is...
To start a database instance, Oracle Database must read either a server parameter file, which is recommended, or a text...
1 min read
The nohup command runs the command specified by the Command parameter and any related Arg parameters, ignoring all hang up...
2 min read
Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private...
2 min read
Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release, Oracle Database 23c, stands for...
3 min read
1. As a laymen, consider a user/application requests a connection request to the Oracle database through his login credential. 2....
2 min read
The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored in the locations /<path to...
4 min read
Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for...
4 min read
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage...
3 min read
Enqueues are locks that coordinate access to database resources. This event indicates that the session is waiting for a lock...
2 min read
This wait indicates that we are waiting for a read operation which reads a number of contiguous blocks from disk....
4 min read
This event signifies that the user process is reading a buffer into the SGA buffer cache and is waiting for...
2 min read
Overview of Inventory: The inventory is a very important part of the Oracle Universal Installer. This is where OUI keeps...
