SPLUNK’s Advance Topic
Macros Search macros are reusable chunks of Search Processing Language (SPL) that you can insert…
Read moreCrontab : RMAN Backup
Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger…
Read moreRoles and Licensing in Splunk
Roles: There are basically three different types of Roles in Splunk:User: This is the basic…
Read moreRecovery Point Objective(RPO) and Recovery Time Objective (RTO)
A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time…
Read moreHow to Change SQL*Plus Prompt to Reflect Username & Instance Name ??
1. Verify that client networking connections are functional. Clients must be able to login to…
Read moreBackground Processes in Oracle ASM
Once the ASM instance is started, all the basic background processes, as well as some…
Read moreRow Chaining and Row Migration
Row Chaining Occurs when the row is too large to fit into one data block…
Read moreOverview of the Program Global Area (PGA)
The PGA is memory specific to an operating process or thread that is not shared…
Read moreOverview of the User Global Area
The UGA is session memory, which is memory allocated for session variables, such as logon…
Read moreGlobal Name Services in RAC
It is small xml file located in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used…
Read moreScript Repositories (All in One…)
DBA-ScriptsDownload
Read moreHow to rename Duplicate datafile names in Oracle??
11g database - Datafile created with extra blank space similar to existing datafile. Please note…
Read moreHow To Modify AWR Snapshot Setting ??
We can change the snap_interval and retention period for the automatic awr snapshot collection, using…
Read moreORA-12101: Materialized View Issue
During 19c Upgrade, Materialized view creation which is from a pre-built base table is showing…
Read moreORA-39358: Export Dump File Version 12.1.0.2.0 Not Compatible With Target Version 11.2.0.4.0
After upgrading a database from 11.2.0.4 to 12.1.0.2, the following errors are reported executing a…
Read moreRAID (Redundant Array of Inexpensive disks)
RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array…
Read moreWhat is Checkpoint ?
A checkpoint is an operation that Oracle performs to ensure data file consistency. When a…
Read moreGrid Infrastructure Files and Management Database in RAC
Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster…
Read moreKilling Hung RMAN Session in Oracle
Sometimes you may need to kill the RMAN session which is hanging and does not…
Read moreEnable/Disable Archive Log Mode In Oracle Database?
ARCHIVELOG mode is a mode that you can put the database in for creating a…
Read moreSPLUNK Commands
Commands: In Splunk, to write a query we need to learn the various commands it…
Read moreServer Parameter File in RAC
During the Creation of database via DBCA , SPFILE is created in the file location…
Read moreRead-only user Creation.
Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the…
Read moreBefore we start tuning GoldenGate…
Large objects (LOBs) LOBs can be a problem in data replication by virtue of their…
Read moreLatching in Oracle
System Locks Oracle Database uses various types of system locks to protect internal database and…
Read more