AWR

How to generate AWR report in RAC

AWR report can be generating in RAC database using 2 scripts awrrpt.sql or awrr...

How to get the execution plan for a SQL between two AWR snapshots

We can get the all the execution plan details of an ...

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 col...

How to modify awr snapshot interval setting

We can change the snap_interval and retention period for the autom...

How to create awr snapshot manually

Automatic Workload Repository (AWR) is a collection of database statis...

How to generate AWR report in oracle

The Automatic Workload Repository (AWR) collects and maintains statistics of...

ORA-13541: system moving window baseline size greater than retention

PROBLEM: While modifying the retention p...