Do AWR Reports Show the Whole Picture?
AWR report is a great source of aggregated information on top activities happening in our databases. I use data collected in AWR quite often, and obviously the easiest way of getting the data out from the AWR is by running the AWR report. In most cases that's not an issue, but there are certain scenarios when it hides the information one is looking for, just because of how it's designed. If I'm trying to collect information about top queries by physical reads, I would normally look at the "SQL ordered by Reads" section and this is what I'd see:
![AWR DIsk reads](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)
- DIFF_PLANS - number of different PLAN_HASH_VALUE values reported for this SQL_ID, and if only one is found - it shows the actual PLAN_HASH_VALUE
- DIFF_FMS - number of different FORCE_MATCHING_SIGNATURE values reported for this SQL_ID, and if only one is found - it shows the actual FORCE_MATCHING_SIGNATURE
![Custom Script - sqlid](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)
![Custom Script - fms](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)
![Custom Script - plan](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)
![Custom Script - sqlids for plan](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)
![All plan sqls](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)
Share this
You May Also Like
These Related Stories
News and updates from Amazon Web Services
News and updates from Amazon Web Services
Sep 12, 2018
6
min read
Anthos Is the future of cloud transformation
![](https://www.pythian.com/hubfs/Imported_Blog_Media/Anthos.jpg)
Anthos Is the future of cloud transformation
Apr 11, 2019
2
min read
News and upates from Microsoft Azure, pt II
News and upates from Microsoft Azure, pt II
Sep 26, 2018
8
min read
No Comments Yet
Let us know what you think