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: SQL plan baselines cannot help in cases where an event has caused irreversible execution plan changes, such as dropping an index. Drop SQL Tuning Set (STS) List distinct plan hash … Read more
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 log files. LogMiner tool can help the DBA to the find changed records in redo log files by using a set of PL/SQL procedures and … Read more
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. Conceptually, a SQL profile is to a SQL statement what object-level statistics are to a table or index. SQL profiles are created when a DBA … Read more
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 the second session until the first session has completed its work. Grant 777 permission to session_lock_asrblg1.sh script for its execution. Find Locked Table Find Lock … Read more
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. As we all know running a slow query is a major performance issue in the database also has the biggest challenge for DBA to resolve … Read more
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 types: Logical backup Logical backup outputs a database structure in a .sql file by generating the CREATE or INSERT statements. Later, this file can be … Read more
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. To resolve this issue, we have to drop materialized view summary first:
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: DIAG_ADR_ENABLED DIAG_SIGHANDLER_ENABLED DIAG_DDE_ENABLED As long as you don’t set “DIAG_ADR_ENABLED = OFF” … ADR will still be enabled for the other services. THIS LOG.XML NEED … Read more
Check the datafile location along with name: Set standby file management parameter to manual before moving datafile: Stop the MRP : Move the datafile now : Bounce the DB to overcome this issue: Open the DB in read only: Start MRP: Now validate ,all datafiles are in same location:
Issue : ORA-16047: DGID mismatch between destination setting and target database Since LOG_ARCHIVE_DEST_3 is getting error, we will defer it and enable it back, which will resolve the issue. Error is now resolved. Hope it worked !! 