SPLUNK’s Dashboard
Overview Dashboards in Splunk are used to represent meaningful information’s in a graphical or statistical…
Read moreRunning nohup commands
The nohup command runs the command specified by the Command parameter and any related Arg…
Read moreSplit Brain Syndrome in RAC
Where two or more instances attempt to control a cluster database. Each node in this…
Read moreAbout Oracle Database Release Numbers
Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release,…
Read moreHow INSERT Statement get executed in Oracle??
1. As a laymen, consider a user/application requests a connection request to the Oracle database…
Read moreWhat Are Root.sh And OrainstRoot.sh Scripts ?
The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored…
Read moreVoting Disk in Oracle RAC
Voting disks manage information about node membership. Each voting disk must be accessible by all…
Read moreOracle Local Registry (OLR) in RAC
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry…
Read moreOracle Wait Events : ” enq: TM – Contention “
Enqueues are locks that coordinate access to database resources. This event indicates that the session…
Read moreOracle Wait Event : ” db_file_scattered_read “
This wait indicates that we are waiting for a read operation which reads a number…
Read moreOracle Wait Events : ” db_file_sequential_reads “
This event signifies that the user process is reading a buffer into the SGA buffer…
Read moreWhat is Global and Local Inventory in Oracle?
Overview of Inventory: The inventory is a very important part of the Oracle Universal Installer.…
Read moreOracle Wait Events : ” enq: TX – Row Lock Contention “
TX lock contention is an application coding, design and usage problem and can ONLY be…
Read moreHow to Identify and Remove the duplicate rows in a Table?
In case if we want to identify duplicates rows of a table and want to…
Read moreSwitchover to Physical Standby Database in Oracle
Once the standby database is configured and verified to be working properly, we can switch…
Read moreBasic Concepts of Index
Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join…
Read moreOracle Database Block Corruption
What is a data block corruption? Data block corruptions occur whenever data is not in…
Read moreThings to know before Upgrading Oracle 12c DB !!
Why there is a need to upgrade Oracle 12c Database? The most important reason to…
Read moreExport/Import Interview Questions-II
What is use of INDEXFILE option in imp? Will write DDLs of the objects in…
Read moreExport/Import Interview questions-I
What is use of CONSISTENT option in exp? When you export a table, you are…
Read moreORA-65011: Pluggable database does not exist.
Below is the error while I was upgrading my test environment. SQL> alter pluggable database…
Read moreWhat is redo log thread?
In Oracle Database, a redo log thread refers to a specific instance of redo log…
Read more“ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired”
Scenario 1: If the jobs are running too frequently, it is possible the queries are…
Read moreFull Table Scan (FTS) in Oracle
A full table scan reads all rows from a table, and then filters out those…
Read moreProtected: Sqlplus (Automation)
There is no excerpt because this is a protected post.
Read more