Day: April 28, 2023

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