3 min read
11g database - Datafile created with extra blank space similar to existing datafile. Please note that oracle database will not...
Month: February 2023
3 min read
1 min read
We can change the snap_interval and retention period for the automatic awr snapshot collection, using modify_snapshot_settings function. The default settings...
1 min read
During 19c Upgrade, Materialized view creation which is from a pre-built base table is showing COMPILATION ERROR without any specific...
1 min read
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...
5 min read
RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array of Independent Disks. This technology...
3 min read
A checkpoint is an operation that Oracle performs to ensure data file consistency. When a checkpoint occurs, Oracle ensures all...
1 min read
Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster . It should have a...
