Common Roles Vs Local Roles
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants…
Read moreOracle
Common 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 moreCrontab : RMAN Backup
Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger…
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 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 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 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 moreAdding Replicats with @RANGE function in GG
Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation).…
Read moreORA-01653: Adding, Resizing of datafiles in Oracle
Datafiles are part of the Oracle Database, these are the files that have the actual…
Read more