Year: 2023
Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
Stats: The stats command is used to calculate summary statistics on the results of a search or the events retrieved from...
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later The unified audit trail can be purged using the DBMS_AUDIT_MGMT...
In which months oracle release CPU patches? JAN, APR, JUL, OCT When we applying single Patch, can you use opatch...
Splunk is a software platform to search, analyse & visualize the machine generated data gathered from different websites, applications, sensors,...
There are 3 different roles in Splunk in order it is Users, Power User & Admin. 1) User : This...
Splunk provides you with 3 different modes of Splunk searches i.e. Fast, Smart & Verbose. Modes of searches can be...
The Meta-data is generally the first command of the search. As a best practice, we should include 4 fields always...
SQL Developer is a convenient way for database developers to edit and develop basic tasks using SQL*Plus. SQL Developer is...
To start a database instance, Oracle Database must read either a server parameter file, which is recommended, or a text...
Overview Dashboards in Splunk are used to represent meaningful information's in a graphical or statistical way in order to get...
The nohup command runs the command specified by the Command parameter and any related Arg parameters, ignoring all hang up...
Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private...
Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release, Oracle Database 23c, stands for...
1. As a laymen, consider a user/application requests a connection request to the Oracle database through his login credential. 2....
The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored in the locations /<path to...
Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for...
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage...
Enqueues are locks that coordinate access to database resources. This event indicates that the session is waiting for a lock...
This wait indicates that we are waiting for a read operation which reads a number of contiguous blocks from disk....
This event signifies that the user process is reading a buffer into the SGA buffer cache and is waiting for...
Overview of Inventory: The inventory is a very important part of the Oracle Universal Installer. This is where OUI keeps...
TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code...
In case if we want to identify duplicates rows of a table and want to remove them from a table. ...