Redolog Buffer Cache : SGA Component of Oracle
The redo log buffer is a circular buffer in the SGA that stores redo entries…
Read moreMarch 2023
Shared /Large/Java/Result Pool: SGA Component of Oracle
The shared pool caches various types of program data.For example, the shared pool stores parsed…
Read moreSPLUNK’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 more