asrblogger, Author at ASRblogger

Overview of the User Global Area

The UGA is session memory, which is memory allocated for session variables, such as logon information, and other information required by a database session. Essentially, the UGA stores the session…

asrblogger March 7, 2023No Comments

RAC

Global 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 to establish the correct global personality of a node. Each node maintains a local copy…

asrblogger March 2, 2023No Comments

Scripts

Script Repositories (All in One…)

DBA-ScriptsDownload

asrblogger March 1, 2023No Comments

Oracle

How to rename Duplicate datafile names in Oracle??

11g database - Datafile created with extra blank space similar to existing datafile. Please note that oracle database will not allow exact datafile name, this happens when user put space…

asrblogger February 26, 2023No Comments

Oracle

How To Modify AWR Snapshot Setting ??

We can change the snap_interval and retention period for the automatic awr snapshot collection, using modify_snapshot_settings function. The default settings for ‘interval’ and ‘retention’ are 60 minutes and 8 days…

asrblogger February 20, 2023No Comments

Oracle

ORA-12101: Materialized View Issue

During 19c Upgrade, Materialized view creation which is from a pre-built base table is showing COMPILATION ERROR without any specific error messages. Base table column had different precision then a…

asrblogger February 13, 2023No Comments

Oracle

ORA-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 datapump import process: Import: Release 12.1.0.2.0 - Production Copyright (c) 1982, 2014, Oracle and/or its…

asrblogger February 10, 2023No Comments

Linux Oracle

RAID (Redundant Array of Inexpensive disks)

RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array of Independent Disks. This technology is now used in almost all the IT organizations looking…

asrblogger February 9, 2023No Comments

Core DBA Interview Questions Oracle

What is Checkpoint ?

A checkpoint is an operation that Oracle performs to ensure data file consistency. When a checkpoint occurs, Oracle ensures all modified buffers are written from the data buffer to disk…

asrblogger February 5, 2023No Comments

RAC

Grid Infrastructure Files and Management Database in RAC

Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster . It should have a Grid Infrastructure Management Repository (GIMR) installed or be a part…