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