1. As a laymen, consider a user/application requests a connection request to the Oracle database through his login credential. 2. This login credential is accepted by the Listener Process which…

The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored in the locations /<path to oraInventory>/orainstRoot.sh and $ORACLE_HOME/root.sh. After the installation is complete a prompt…

Enqueues are locks that coordinate access to database resources. This event indicates that the session is waiting for a lock that is held by another session. The V$EVENT_NAME view provides…

This wait indicates that we are waiting for a read operation which reads a number of contiguous blocks from disk. In most cases this indicates that there is some form…

This event signifies that the user process is reading a buffer into the SGA buffer cache and is waiting for a physical I/O call to return. A sequential read is…

Overview of Inventory: The inventory is a very important part of the Oracle Universal Installer. This is where OUI keeps all information regarding the products installed on a specific machine.…

TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code with more frequent and explicit COMMIT statements and any other…