Trend Identification with the AWR

SQL> @report_sysstat_day
 
This will query the dba_hist_sysstat view to display
average values by day-of-the-week

Enter Statistics Name:  physical reads


SNAP_TIME              AVG_VALUE
------------------ ------------
sunday                   190,185
monday                   135,749
tuesday                   83,313
wednesday                139,627
thursday                 105,815
friday                   107,250
saturday                 154,279

This report shows an average for every day of the week. These types of signatures will become very stable for most Oracle databases, and they can be used to develop a predictive model for proactive tuning activities.

Figure 4.15 - Signature for average physical reads by day of the week