Day: October 20, 2023

How INSERT Statement get executed in Oracle??

by

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 is present on the server side. 3. PMON checks the authenticity of the user in the data dictionary cache of the Shared Pool. If the … Read more

What Are Root.sh And OrainstRoot.sh Scripts ?

by

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 is diplayed to run these scripts as the root user. The following configuration scripts need to be executed as the “root” user Scripts to be … Read more