AWR

How to generate AWR report in RAC

AWR report can be generating in RAC database using 2 scripts awrrpt.sql or awrrpti.sql awrrpt.sql – > This will generate the one report for the database across all the nodes(i.e for all insta...

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

We can get the all the execution plan details of an sql_id for a particular awr snapshot. EXAMPLE: sql_id – > 5vqy6cj4jr89k Run the below script: start $ORACLE_HOME/rdbms/admin/awrsqrpt.sql ...

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 colored, it will be captured in every snapshot, independent of its level of activities  (so that it does not have to b...

How to modify awr snapshot interval setting

We can change the snap_interval and retention period for the automatic awr snapshot collection, using modify_snapshot_settings function. The default settings for ‘interval’ and ‘rete...

How to create awr snapshot manually

Automatic Workload Repository (AWR) is a collection of database statistics owned by the SYS user. By default snapshot are generated once every 60min . But In case we wish to generate awr ...

How to generate AWR report in oracle

The Automatic Workload Repository (AWR) collects and maintains statistics of the database. We can generate awr report for a particular time frame in the past using the script awrrpt.sql ( located unde...

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

PROBLEM: While modifying the retention period of AWR snapshot, got error ORA-13541 SQL> execute dbms_workload_repository.modify_snapshot_settings (interval => 30, retention => 10080); BEGIN d...