http://netvouz.com/MondoTofu/tag/awr?feed=rss MondoTofu's bookmarks tagged "awr" on Netvouz https://blogs.oracle.com/UPGRADE/entry/how_to_select_statements_from How to pick SQL statements out of AWR to create a workload for DBMS_Advisor runs Oracle > Optimization MondoTofu Thu, 09 Apr 2015 20:19:53 GMT http://kerryosborne.oracle-guy.com/2008/10/unstable-plans/ unstable plans what changed oracle execution awr snapshot Oracle > Optimization MondoTofu Tue, 19 Jul 2016 13:34:55 GMT http://kerryosborne.oracle-guy.com/2009/12/tracking-parameter-changes/ tracking changes, retain AWR history Oracle > Optimization MondoTofu Fri, 06 Jun 2014 21:10:50 GMT http://kerryosborne.oracle-guy.com/2009/06/what-did-my-new-index-mess-up/ find significantly different average elapsed times per execution. It uses AWR data and computes a normalized standard deviation between the average elapsed time per execution before and after the date specified by the days_ago parameter Oracle > DB 11g MondoTofu Fri, 06 Jun 2014 15:02:24 GMT http://www.dba-oracle.com/oracle_tips_unused_indexes.htm Find unused Indexes by querying AWR Oracle > DB 11g MondoTofu Tue, 24 Mar 2015 19:56:09 GMT http://ora-performance-tuning.blogspot.com/2013/12/awr-reports-introduction-awr.html Descriptive information in AWR 11g special scripts Automatic Workload Repository Report awrrpt.sql Automatic Database Diagnostics Monitor Report addmrpt.sql ASH Report ashrpt.sql AWR Diff Periods Report awrddrpt.sql AWR Single SQL Statement Report awrsqrpt.sql AWR Global Report awrgrpt.sql AWR Global Diff Report awrgdrpt.sql Oracle > Optimization MondoTofu Fri, 17 Jul 2015 16:38:12 GMT