Home 2023 October

Monthly Archives: October 2023

silhouette photo of person holding door knob

Running nohup commands

0
The nohup command runs the command specified by the Command parameter and any related Arg parameters, ignoring all hang up signals (SIGHUP) or modifies...
an artist s illustration of artificial intelligence ai this image represents how machine learning is inspired by neuroscience and the human brain it was created by novoto studio as par

Split Brain Syndrome in RAC

0
Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private interconnect and end...
white ruled notebook

About Oracle Database Release Numbers

0
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....
crop unrecognizable man inserting flashcard into laptop slot

How INSERT Statement get executed in Oracle??

0
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...
set of various folders for documents

What Are Root.sh And OrainstRoot.sh Scripts ?

0
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...
woman in red clothes with big disk

Voting Disk in Oracle RAC

0
Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for nodes to be members...
set of various folders for documents

Oracle Local Registry (OLR) in RAC

0
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage information about node membership. Each...
blur bowed stringed instrument classic classical

Oracle Wait Events : ” enq: TM – Contention “

0
Enqueues are locks that coordinate access to database resources. This event indicates that the session is waiting for a lock that is held by...
blur bowed stringed instrument classic classical

Oracle Wait Event : ” db_file_scattered_read “

0
This wait indicates that we are waiting for a read operation which reads a number of contiguous blocks from disk. In most cases this...
blur bowed stringed instrument classic classical

Oracle Wait Events : ” db_file_sequential_reads “

0
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...
File drawer clipart, furniture vintage

What is Global and Local Inventory in Oracle?

0
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...
blur bowed stringed instrument classic classical

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

0
TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code with more frequent and...
man head duplicated

How to Identify and Remove the duplicate rows in a Table?

0
In case if we want to identify duplicates rows of a table and want to remove them from a table.  Below are the command...
white and red panic alarm switch

Protected: Switchover to Physical Standby Database in Oracle

0
Once the standby database is configured and works fine then we can switchover to standby database for testing purpose to reduce the primary database...
magnifying glass on book

Basic Concepts of Index

0
Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join indexes, function-based indexes, reverse key indexes and text indexes...
rough shabby brick wall of aged building

Oracle Database Block Corruption

0
What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. Data Block corruptions are one of the...
round blue and gray arrow symbol

Things to know before Upgrading Oracle 12c DB !!

0
Why there is a need to upgrade Oracle 12c Database? The most important reason to upgrade 12c is to enjoy continued access to Oracle support....
woman in black blazer sitting being interview

Export/Import Interview Questions-II

0
What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified file. What is use of IGNORE...
woman in black blazer sitting being interview

Export/Import Interview questions-I

0
What is use of CONSISTENT option in exp? When you export a table, you are guaranteed that the contents of that table will be consistent...
Free missing jigsaw

ORA-65011: Pluggable database does not exist.

0
Below is the error while I was upgrading my test environment. SQL> alter pluggable database application CODDY begin upgrade '1.3' to '1.4'; alter pluggable database application...
needle and three assorted color sewing threads

What is redo log thread?

0
Each instance has it's own personal set of redo and each redo thread is made up of at least two groups that have one...
close up shot of floppy disks

“ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired”

0
Scenario 1: If the jobs are running too frequently, it is possible the queries are not releasing the lock and resulting in the error: “ORA-00054:...
Bar table png sticker, transparent

Full Table Scan (FTS) in Oracle

0
A full table scan reads all rows from a table, and then filters out those rows that do not meet the selection criteria. Just because...
paying attention to details

Protected: Sqlplus (Automation)

0
Script named “sp” created for a few purposes. One to provide a shortcut for the thousands of times a week I enter “sqlplus /...
close up of open book

HugePages in Linux

0
Computer memory is managed in blocks of storage known as pages, which have a predetermined size that depends on the computer’s architecture. These pages...