Analyze Database Interconnect Activity

View the current interconnect activity trend, compare interconnect activity across databases, and forecast future interconnect resources for a later time period.

Analyze Interconnect Trend Over Time

The Interconnect section under the Overview tab displays the current trend of interconnect activity in terms of bytes sent, across the selected databases for the specific time period.

Alternatively, click the Interconnect tile in the navigation pane to view the current trend of interconnect activity and forecast future activity.

Figure - Aggregate Interconnect Across All Databases Chart

Description of "Figure - Aggregate Interconnect Across All Databases Chart"

Compare Interconnect Activity Between Databases

The Interconnect Breakdown by Individual Databases chart lets you compare the interconnect activity of your different databases.

1. Click the Group by list to select what metrics to group the databases by.

   • Life Cycle Status

   • Target Version

   • Cost Center

   • Host Name

   • Contact

2. To view the 10 databases with the highest interconnect activity, from the Group by list, select Top 10 databases.
3. Select the databases for which you want to view specific information.

The volume and percentage changes of the interconnect activity are represented by the size and color of the cells, respectively. Cells that are larger have greater interconnect activity than smaller cells. The largest cell would be that of the database with the highest interconnect activity. The color of the cells is determined by the percentage change in the interconnect activity during the specified time period.

Analyze Current Interconnect Trend and Forecast Activity

From the Trend and Forecast chart, you can view the current trend of interconnect activity, and use this trend to forecast future interconnect activity.

1. From the sectionTrend and Forecast, in the Filters field, enter the name of the database. You can enter multiple databases in the Filters field. Alternatively, in the Interconnect Breakdown by Individual Databases section, use Ctrl + Shift to select multiple databases.
   The data for the selected databases loads in the Trend and Forecast section.
2. To set the Regression Model, Forecast Period, and Confidence (%), click Settings.
3. Click Run.

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 the Oracle IT Analytics warehouse.

You can use the forecast and current interconnect activity for capacity planning.

Figure - Trend and Forecast Chart for Interconnect Activity

Description of "Figure - Trend and Forecast Chart for Interconnect Activity"