October 2023 - ASRblogger

SPLUNK’s Dashboard

Overview Dashboards in Splunk are used to represent meaningful information's in a graphical or statistical way in order to get the business insights. It basically consists of panels. Each panel…

asrblogger October 26, 2023No Comments

Linux Oracle

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 RAC

Voting Disk in Oracle RAC

Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for nodes to be members of the cluster1. You can store…

asrblogger October 18, 2023No Comments

Oracle RAC

Oracle Local Registry (OLR) in RAC

Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage information about node membership. Each voting disk must be accessible…

asrblogger October 18, 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…