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,…
Read MoreApril 2023
LOG MINER in Oracle
Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live…
Read MoreManual creation of SQL Profiles in Oracle Database
SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle…
Read MoreCrontab : Blocking session
Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and…
Read MoreHow To Run SQL Tuning Advisor
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning…
Read MoreMEB Backup & Restore in MySQL
MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking…
Read MoreORA-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…
Read MoreUnable to generate Listener Log in Prod RAC DB
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the…
Read MoreMoving datafile from one location to another in Standby
Check the datafile location along with name: Set standby file management parameter to manual before…
Read MoreORA-16047: DGID mismatch between destination setting and target database
Issue : ORA-16047: DGID mismatch between destination setting and target database Since LOG_ARCHIVE_DEST_3 is getting…
Read More