How to Stop Auto Refresh of Materialized View ??
A materialized view create with the automatic refresh can not be alter to stop refreshing.…
Read moreMay 2023
Reports and Alerts in SPLUNK
Overview Alerts in Splunk are used to create notification or inform someone when a particular…
Read moreBlock Change Tracking: RMAN Performance
Oracle RMAN was able to take incremental backups already in 9i. However, prior to introduction…
Read moreHow to use IMPDP with transform=disable_archive_logging:y
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will…
Read moreScript to identify SQL generating Redo
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)…
Read moreSystem Monitor Process (SMON) : Oracle Background Process.
SMON Performs critical tasks such as crash recovery when the instance is started following a…
Read moreUpgrade the database time zone (TZ) file using the DBMS_DST package in 19c.
After upgrading database from 12c to 19c, you may need to upgrade database time zone…
Read moreDatabase Writer Process (DBWn) : Oracle Background Process
Writes modified blocks from the database buffer cache to the data files. The database writer…
Read moreManageability Monitor Process (MMON) and Manageability Monitor Lite Process (MMNL) : Oracle Background Process
MMON Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing…
Read moreFAL (Fetch Archive Log) Gap Resolution
Once an Archive Log is received or archived from a Standby Redo Log on the…
Read more