How to generate AWR report in RACAWR 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 snapshotsWe can get the all the execution plan details of an ...
What is colored sql_id in dba_hist_colored_sqlBy default, only top sql_ids are captured in database snapshots. If an SQL ID is col...
How to modify awr snapshot interval settingWe can change the snap_interval and retention period for the autom...
How to create awr snapshot manuallyAutomatic Workload Repository (AWR) is a collection of database statis...
How to generate AWR report in oracleThe Automatic Workload Repository (AWR) collects and maintains statistics of...
ORA-13541: system moving window baseline size greater than retentionPROBLEM: While modifying the retention p...