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: [crayon-5cbe7521839d0391315648/] We need to ...
AWR
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 [crayon-5cbe752184e7e465538015/] SOLUTION: Here we are trying to set retention to 10080 which is equal to 7 days. Let...