Oracle Archives - Page 16 of 30

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

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

Oracle RAC

Killing Hung RMAN Session in Oracle

Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways to terminate an RMAN command in the middle of execution:…

asrblogger January 29, 2023No Comments

Oracle

Enable/Disable Archive Log Mode In Oracle Database?

ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover…

asrblogger January 23, 2023No Comments

Oracle RAC

Server Parameter File in RAC

During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location can be an ASM disk group, cluster file system file,…