2 min read
Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private...
asrblogger
2 min read
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...
4 min read
TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code...
1 min read
In case if we want to identify duplicates rows of a table and want to remove them from a table. ...
3 min read
Once the standby database is configured and verified to be working properly, we can switch over to the standby database...
6 min read
Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join indexes, function-based indexes, reverse key...
3 min read
Block-Corruption-RecoveryDownload What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. Data...
3 min read
Why there is a need to upgrade Oracle 12c Database? The most important reason to upgrade 12c is to enjoy...
2 min read
What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified...
9 min read
What is use of CONSISTENT option in exp? When you export a table, you are guaranteed that the contents of...
2 min read
Below is the error while I was upgrading my test environment. SQL> alter pluggable database application CODDY begin upgrade '1.3'...
3 min read
In Oracle Database, a redo log thread refers to a specific instance of redo log processing within the database. Redo...
3 min read
Scenario 1: If the jobs are running too frequently, it is possible the queries are not releasing the lock and...
2 min read
A full table scan reads all rows from a table, and then filters out those rows that do not meet...
1 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
Computer memory is managed in blocks of storage known as pages, which have a predetermined size that depends on the...
3 min read
On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and if Oracle...
