How to generate AWR report in RAC
AWR report can be generating in RAC database using 2 scripts awrrpt.sql or ...
AWR
How to get the execution plan for a SQL between two AWR snapshots
We can get the all the execution plan details of...
What is colored sql_id in dba_hist_colored_sql
By default, only top sql_ids are captured in database snapshots. If an SQL ID is...
How to modify awr snapshot interval setting
We can change the snap_interval and retention period for the a...
How to create awr snapshot manually
Automatic Workload Repository (AWR) is a collection of database st...
How to generate AWR report in oracle
The Automatic Workload Repository (AWR) collects and maintains statistic...
ORA-13541: system moving window baseline size greater than retention
PROBLEM: While modifying the retenti...