Analyze Database Storage Usage

View the current space usage trend, compare storage utilization across databases, and forecast future storage resources for a later time period.

Analyze Available Storage Resources

The Allocated Storage section under the Overview tab displays the current tablespace usage.

Alternatively, click the Storage tab in the navigation pane to view the aggregate storage utilization.

Figure - Aggregated Forecast View

Description of "Figure - Aggregated Forecast View"

From this chart, you can view the trend of space utilization.

Compare Storage Utilization Between Databases

The Storage breakdown by individual databases chart lets you compare how your different databases use your available storage.

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

   • Life Cycle Status

   • Target Version

   • Cost Center

   • Contact

   • Database Type

2. To view the 10 databases with the most storage resources, from the Group By list, select Top 10.
3. To view the storage resources split on the basis of pluggable databases, select Split by Pluggable Databases (Top 10).
4. Select the databases for which you want to view specific information. Use Ctrl + Shift to select multiple databases.
5. To view the list of databases, and their relevant information such as the DB type, space used, change %, hostname, target version, life cycle, and cost center in a CSV format, click Download CSV.

The volume of storage resources used and the percentage change are represented visually, through the size and color of the cells, respectively. Cells that are larger in size use more storage resources than smaller cells. The largest cell would be that of the databases using the most storage resources. The color of the cells is determined by the percentage change in the storage resources used by the databases.

Analyze Current Storage Trend and Forecast Utilization

From the Trend/Forecast across databases chart, you can view the current trend of storage utilization, and use this trend to forecast future resource utilization.

1. In the Trend/Forecast across databases section, in the Filters field, enter the name of the database. You can enter up to five databases in the Filters field.
   Alternatively, you can select the database in the Storage breakdown by individual databases section.
   The data for the selected database 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/Forecast across databases section.

For the 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 current and forecast storage utilization to plan your database capacity.

Figure - Trend/Forecast Across Databases Chart

Description of "Figure - Trend/Forecast Across Databases Chart"

For example, if according to the forecast storage space utilization, the storage requirements will gradually increase, then you need to expand your storage capacity to allow for this forecast increase in storage needs.

View Tablespace Breakdown by Database

In addition to the consolidated trend and forecast for the selected databases, you can view:

• Space allocation breakdown by individual databases

• Trend and forecast per database

• Usage of each tablespace for an individual database

Click more... to view the usage breakdown for that database, by tablespace.

Figure - Usage Breakdown by Tablespaces Chart

Description of "Figure - Usage Breakdown by Tablespaces Chart"