1 min read
Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
Oracle
1 min read
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...
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. ...
5 min read
This content is password protected. To view it please enter your password below: Password:
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
What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. Data Block...
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'...
