Oracle Archives - Page 12 of 30

How to Stop Auto Refresh of Materialized View ??

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…

asrblogger May 31, 2023No Comments

Oracle

Block Change Tracking: RMAN Performance

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…

asrblogger May 25, 2023No Comments

DataGuard Oracle

How 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 be generated for the whole impdp job. The ideology behind this feature is, when import…

asrblogger May 21, 2023No Comments

Oracle

Script 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) sql, dhss.instance_number inst_id, dhss.sql_id, sum(executions_delta) exec_delta, sum(rows_processed_delta) rows_proc_delta FROM dba_hist_sqlstat dhss, dba_hist_snapshot dhs, dba_hist_sqltext dhst…

asrblogger May 20, 2023No Comments

Interview Questions Oracle

System Monitor Process (SMON) : Oracle Background Process.

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,…

asrblogger May 15, 2023No Comments

Oracle

Upgrade 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 file version. This step is not always mandatory, but it is recommended by pre-upgrade checker.…

asrblogger May 13, 2023No Comments

Oracle

Database Writer Process (DBWn) : Oracle Background Process

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…

asrblogger May 8, 2023No Comments

Oracle

Manageability 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 Automatic Database Diagnostic Monitor analysis. MMNL Performs tasks relating to manageability, including active session history…

asrblogger May 6, 2023No Comments

DataGuard Oracle

FAL (Fetch Archive Log) Gap Resolution

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…

asrblogger May 2, 2023No Comments

Oracle

Query is picking a bad execution plan , fix it using Oracle baselines ?

The goal of SQL plan baselines is to preserve the performance of corresponding SQL statements, regardless of changes in the database. Examples of changes include: New optimizer version Changes to…