Oracle Archives - Page 13 of 30

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…

asrblogger April 28, 2023No Comments

Oracle

LOG MINER in Oracle

Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live and archived redo log files. The history of activity on a database is stored in redo…

asrblogger April 28, 2023No Comments

Oracle RAC

Manual creation of SQL Profiles in Oracle Database

SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database object that contains auxiliary statistics specific to a SQL statement.…

asrblogger April 26, 2023No Comments

Oracle

Crontab : Blocking session

Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and doesn’t release it before another sessions wants to update the same data. This will block…

asrblogger April 26, 2023No Comments

Oracle RAC

When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be used to improve performance. It might give suggestion to create few indexes or accepting a SQL profile.…

asrblogger April 26, 2023No Comments

Oracle

ORA-04021: timeout occurred while waiting to lock object while dropping Materialized View.

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table.…

asrblogger April 26, 2023No Comments

DataGuard Oracle

Unable to generate Listener Log in Prod RAC DB

Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the both the nodes and restarted the listener DIAG_ADR_ENABLE_LISTENER=OFF There are 3 parameters associated with ADR:…

asrblogger April 26, 2023No Comments

DataGuard Oracle

Moving datafile from one location to another in Standby

[oracle@localhost ~]$ ps -ef|grep pmon oracle 2113 1 0 Sep20 ? 00:54:32 ora_pmon_prod1 oracle 30032 29996 0 08:50 pts/0 00:00:00 grep --color=auto pmon [oracle@localhost ~]$ [oracle@localhost ~]$ [oracle@localhost ~]$ .…

asrblogger April 26, 2023No Comments

DataGuard Oracle

ORA-16047: DGID mismatch between destination setting and target database

Issue : ORA-16047: DGID mismatch between destination setting and target database alert.log alter database register logfile '/opt/data/oracle3/prod101/FRA/prod101/archivelog/2019_12_01/o1_mf_1_190698_gy5z61jw_.arc' There are 1 logfiles specified. ALTER DATABASE REGISTER [PHYSICAL] LOGFILE Completed: alter database…