Undo Tablespace
There are two types of Undo Modes in 12.2 1) Shared Undo - The Undo…
Read more2023
Renaming and Relocating Datafiles Online
Relocating an Online Data File Copying an Online Data File This example copies the data…
Read moreOracle Managed Files 11g & 12c
11g When OMF is enabled and If a datafile location is incorrect the file gets…
Read moreManaging Tablespace in CDB and PDB
Managing tablespace in container database is similar to non-container database. Provided you are logged in…
Read moreCommon user password change:
Common user password we can change from only cdb level .container class is optional.
Read moreOracle-maintained users password change
From oracle 12c onwards the default user’s account passwords have to change from cdb container.…
Read moreLockdown Profile:
From 12c onwards we have new feature called lockdown profile to control the PDB level…
Read moreCommon Roles Vs Local Roles
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants…
Read moreCommon Grant Vs Local Grant
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants…
Read moreRedolog Buffer Cache : SGA Component of Oracle
The redo log buffer is a circular buffer in the SGA that stores redo entries…
Read moreShared /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 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 more