1 min read
A materialized view create with the automatic refresh can not be alter to stop refreshing. In order to do that...
Month: May 2023
1 min read
2 min read
Overview Alerts in Splunk are used to create notification or inform someone when a particular situation is met. It basically...
4 min read
Oracle RMAN was able to take incremental backups already in 9i. However, prior to introduction of Oracle 10g block change...
1 min read
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will be generated for the whole...
1 min read
SELECT when, sql, SUM(sx) executions, sum (sd) rows_processed FROM ( SELECT to_char(begin_interval_time,’YYYY_MM_DD HH24′) when, dbms_lob.substr(sql_text,4000,1) sql, dhss.instance_number inst_id, dhss.sql_id, sum(executions_delta)...
1 min read
SMON Performs critical tasks such as crash recovery when the instance is started following a failure, dead transaction recovery, and...
3 min read
After upgrading database from 12c to 19c, you may need to upgrade database time zone file version. This step is...
1 min read
Writes modified blocks from the database buffer cache to the data files. The database writer process (DBWn) reads the database...
2 min read
MMON Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis....
3 min read
Once an Archive Log is received or archived from a Standby Redo Log on the Standby Database, it is registered...
