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 character in file name, so it looks like duplicate filename but it will be different. So user wanted to rename such files, below is the … Read more
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 . The dba_hist_wr_control table shows the AWR snapshot settings, namely the snapshot interval, the retention period and the top-x-sql collection threshold: AWR Snapshot Reports Oracle … Read more
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 pre-built materialized view table and it caused the COMPILATION_ERROR without specifying the correct error message. –> both these columns precision is different. it should be … Read more
After upgrading a database from 11.2.0.4 to 12.1.0.2, the following errors are reported executing a datapump import process: CAUSE The issue is because the COMPATIBLE parameter for the 12c importing database is still 11.2.0.4 (value before the upgrade). It was confirmed based on the information provided: 1. Version of the exporting database 12c (12.1.0.2.0), compatible … Read more
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 for data redundancy and better performance. It combines multiple available disks into 1 or more logical drive and gives you the ability to survive one … Read more
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 files. Frequent checkpoints decrease the time necessary for recovery should the database crash, but may decrease overall database performance. A checkpoint performs the following three … Read more
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 of a Domain Service Cluster having a GIMR. In Oracle 19c Grid Infrastructure, the GIMR is not required for a Standalone Cluster but recommended. If … Read more