A materialized view create with the automatic refresh can not be alter to stop refreshing. In order to do that you must break the dbms_job that was created in order to refresh the view. Follow the steps for 12.2.0.1: 1. Connect as mview owner. 2. select * from user_jobs where broken =’N’; 3. In the … Read more
Overview Alerts in Splunk are used to create notification or inform someone when a particular situation is met. It basically is used to notify the support team when any service degradation happens so that they can work and fix the issue. The difference between dashboards and alerts is that dashboards needs to be manually monitored … Read more
Oracle RMAN was able to take incremental backups already in 9i. However, prior to introduction of Oracle 10g block change tracking (BCT), RMAN had to scan the whole datafile to and filter out the blocks that were not changed since base incremental backup and overhead or incremental backup was as high as full backup. Oracle … Read more
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will be generated for the whole impdp job. The ideology behind this feature is, when import process is going on with logging and “we can see huge redo log generations which leads to frequent log switches [depending on the exported objects] … Read more
SMON Performs critical tasks such as crash recovery when the instance is started following a failure, dead transaction recovery, and maintenance tasks such as temporary space reclamation, data dictionary cleanup, and undo tablespace management. The system monitor process (SMON) performs many database maintenance tasks, including the following: *Creates and manages the temporary tablespace metadata and … Read more
After upgrading database from 12c to 19c, you may need to upgrade database time zone file version. This step is not always mandatory, but it is recommended by pre-upgrade checker. Useful info about its necessity from Oracle site: https://oracle-base.com/articles/misc/update-database-time-zone-file Below recommend action is from preupgrade.jar information tool. The error that may customer received when he … Read more
Writes modified blocks from the database buffer cache to the data files. The database writer process (DBWn) reads the database buffer cache and writes modified buffers to data files. It also handles checkpoints, file open synchronization, and logging of Block Written records. DBWn also reads the Database Smart Flash Cache (Flash Cache) when Flash Cache … Read more
MMON Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis. MMNL Performs tasks relating to manageability, including active session history sampling and metrics computation. The manageability monitor process (MMON) and manageability monitor lite process (MMNL) perform tasks related to the Automatic Workload Repository (AWR). The … Read more
Once an Archive Log is received or archived from a Standby Redo Log on the Standby Database, it is registered in the Standby Control file (you can query the Registration by v$archived_log on a Physical Standby Database and dba_logstdby_log on a Logical Standby Database). If such a File is missing or corrupted for any Reason … Read more