April 2023 - ASRblogger

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

MySQL

MEB Backup & Restore in MySQL

MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking backups on multiple platforms including Linux, Windows, Mac & Solaris. MySQL supports the following backup…

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…

asrblogger April 26, 2023No Comments

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

LOG MINER in Oracle

Manual creation of SQL Profiles in Oracle Database

Crontab : Blocking session

How To Run SQL Tuning Advisor

MEB Backup & Restore in MySQL

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

Unable to generate Listener Log in Prod RAC DB

Moving datafile from one location to another in Standby

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

Trending Topics.

Get the Latest Blogging Tips Straight to Your Inbox!