Analyze Current I/O Trend and Forecast Activity

From the Aggregated Forecast View chart, you can view the current trend of I/O activity, and use this trend to forecast future I/O activity.

1. In the section Trend/Forecast across databases, in the Filters field, enter the name of the database. You can enter up to five databases in the Filters field. Alternatively, in the IO breakdown by individual databases section, use Ctrl + Shift to select multiple databases.

   The data for the selected databases loads in the Trend/Forecast across databases section.

2. To set the Regression Model, Forecast Period, and Confidence (%), click Settings.
3. Click Run.

   The information loads in the Trend and Forecast section.

For the Database Resource Analytics application to forecast your resource utilization for a year, there must be at least 13 months of data stored in the Oracle IT Analytics warehouse. The forecast value is more accurate when there’s more data stored in theOracle IT Analytics warehouse.

You can use the current and forecast I/O activity to plan your database capacity.

Figure 3-5 I/O Trend and Forecast Chart

Description of "Figure 3-5 I/O Trend and Forecast Chart"

For example, if the forecast I/O activity is at a high level, then you must ensure that you have sufficient resources to support the elevated I/O activity.