Trend Identification with the AWR

The report below displays data averaged for every hour of the day.  This information can then be easily pasted into an MS-Excel spreadsheet and plotted with the chart wizard. See Figure 4.14 for an example chart.

SQL> @report_sysstat_hour
 
This will query the dba_hist_sysstat view to
display average values by hour of the day

Enter Statistics Name:  physical reads

SNAP_TIME              AVG_VALUE
------------------- ------------
00                       120,861
01                       132,492
02                       134,136
03                       137,460
04                       138,944
05                       140,496
06                       141,937
07                       143,191
08                       145,313
09                       135,881
10                       137,031
11                       138,331
12                       139,388
13                       140,753
14                       128,621