Oracle Archives - Page 7 of 30

Running nohup commands

The nohup command runs the command specified by the Command parameter and any related Arg parameters, ignoring all hang up signals (SIGHUP) or modifies the process specified with the -p…

asrblogger October 22, 2023No Comments

Oracle RAC

Split Brain Syndrome in RAC

Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private interconnect and end users connects to cluster through public network.…

asrblogger October 21, 2023No Comments

Interview Questions Oracle

About Oracle Database Release Numbers

Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release, Oracle Database 23c, stands for "Cloud". Previous releases (e.g. Oracle Database 10g and Oracle9i Database)…

asrblogger October 21, 2023No Comments

Oracle

How INSERT Statement get executed in Oracle??

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…

asrblogger October 20, 2023No Comments

Oracle

What Are Root.sh And OrainstRoot.sh Scripts ?

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…

asrblogger October 20, 2023No Comments

Oracle

Oracle Wait Events : ” enq: TM – Contention “

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…

asrblogger October 18, 2023No Comments

Oracle

Oracle Wait Event : ” db_file_scattered_read “

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…

asrblogger October 18, 2023No Comments

Oracle

Oracle Wait Events : ” db_file_sequential_reads “

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…

asrblogger October 17, 2023No Comments

Oracle

What is Global and Local Inventory in Oracle?

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.…

asrblogger October 17, 2023No Comments

Oracle

Oracle Wait Events : ” enq: TX – Row Lock Contention “

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…