This content is password protected. To view it please enter your password below: Password:
Oracle
Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
Grid-Installation-ASRBLG-1Download Hope it helped !! :)
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later The unified audit trail can be purged using the DBMS_AUDIT_MGMT...
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...
The nohup command runs the command specified by the Command parameter and any related Arg parameters, ignoring all hang up...
Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private...
Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release, Oracle Database 23c, stands for...
1. As a laymen, consider a user/application requests a connection request to the Oracle database through his login credential. 2....
The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored in the locations /<path to...
Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for...
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage...
Enqueues are locks that coordinate access to database resources. This event indicates that the session is waiting for a lock...
This wait indicates that we are waiting for a read operation which reads a number of contiguous blocks from disk....
This event signifies that the user process is reading a buffer into the SGA buffer cache and is waiting for...
Overview of Inventory: The inventory is a very important part of the Oracle Universal Installer. This is where OUI keeps...
TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code...
In case if we want to identify duplicates rows of a table and want to remove them from a table. ...
This content is password protected. To view it please enter your password below: Password:
Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join indexes, function-based indexes, reverse key...
What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. Data Block...
Why there is a need to upgrade Oracle 12c Database? The most important reason to upgrade 12c is to enjoy...
What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified...