Oracle Archives - Page 16 of 30

Row Chaining and Row Migration

Row Chaining Occurs when the row is too large to fit into one data block when it is first inserted. In this case, Oracle stores the data for the row…

asrblogger March 12, 2023No Comments

Interview Questions Oracle

Overview of the Program Global Area (PGA)

The PGA is memory specific to an operating process or thread that is not shared by other processes or threads on the system. Because the PGA is process-specific, it is…

asrblogger March 8, 2023No Comments

Interview Questions Oracle

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:…