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 depicts some information about the panel. Thus multiple such panels combined together forms a “Dashboard”. There are basically three types of Dashboards:• Operational Dashboards – … Read more
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 option to ignore all SIGHUP signals. SIGHUP is a signal that is sent to a process when the controlling terminal of the process is closed. … Read more
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. When nodes are physically up and running and Database Instance on each of these servers is also running but private interconnect fails between two or … Read more
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) have used suffixes of “g” and “i” which stand for “Grid” and “Internet” respectively. Prior to the release of Oracle8i Database, no suffixes featured in … Read more
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
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
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 OCR and voting disks on Oracle Automatic Storage Management (Oracle ASM)2. If it is stored in ASM, no need to configure manually as the files … Read more
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 by all nodes in the cluster for nodes to be members of the cluster. ■ OCR manages Oracle Clusterware and Oracle RAC database configuration information. … Read more
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 a complete list of all the enq: wait events. TM enqueue: The most common reason for waits on TM locks tend to involve foreign key … Read more
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 of full scan (index fast full or full table scan) involved. This event signifies that the user process is reading buffers into the SGA buffer … Read more