AWR Report issues
An overview of problems with manual data collection from database hosts which led me to write Dbcollect.
AWR
Format
AWR can be produced in text or html format. There are versions for RAC and per-instance.
Locale
The current "locale" settings can have an effect on how timestamps are presented
Interval
Sometimes people produce AWR reports with very long intervals/time periods (one day or even much more). These are only barely useful. Like asking why there is a traffic jam on Mondays at 9AM where all data you have is the average amount of cars per hour for a full month.
Capacity
"Our database size is 5 Terabyte". OK cool. Is this:
- Size of tablespaces? Tables? Something else?
- Size of ASM diskgroups or filesystems?
- Allocated or used?
- Including archivelogs, backups, exports, etc? Can we split by category?
- Marketing or Engineering numbers?
- Including snapshots Data Guard standby?
- ASM / LVM mirrored copies?
- Using compression? What ratio?
- What is the retention of archivelogs, backups, etc?
Completeness
Are more databases running on the same host? Are there other application processes?
System configuration
What CPU type and model is being used? Are we virtualized? What hypervisor? What OS level? Memory configuration? File systems? Attached disks?