23.3.02 OEM View - Database Capacity
The BMC Helix Continuous Optimization OEM View - Database Capacity page shows capacity of each database instances. It contains a summary table shows database metrics and tablespace aggregated information.
Capacity Table
The table below summarize the information that is provided by the tab, by selecting hidden columns, you can see all the provided columns:
Column Name | Description | Source Metrics or Calculation |
|---|---|---|
Database Name | Database instance name, this is the link to the detailed database instance page | ENTNAME |
DB Total Allocated Size [GB] | The already allocated space for data, logs and control files | DB_TOTAL_ALLOCATED_SIZE [95th] |
DB Total Used Size [GB] | The amount of used space within the allocated space | DB_TOTAL_USED_SIZE [95th] |
DB Total Used Size Trend[GB] | Slope the amount of used space within allocated space | Slope (DB_TOTAL_USED_SIZE) |
Number of Tablespaces | Number of the tablespaces | |
Number of Tablespace in Good Status | number of the tablespaces' cpu utilization is in good status. CPU utilization is better than good threshold | COUNT(BYDB_DATA_USED_SIZE_PCT < BYDS_DATA_USED_SIZE_GOOD_THRESHOLD) |
Number of Tablespace in Warn Status | number of the tablespaces' cpu utilization is in warn status. CPU Utilization is in between good threshold and warn threshold | COUNT(BYDS_DATA_USED_SIZE_WARN_THRESHOLD>BYDB_DATA_USED_SIZE_PCT >BYDS_DATA_USED_SIZE_GOOD_THRESHOLD) |
Number of Tablespace in Err Status | number of the tablespaces' cpu utilization is in err status. CPU Utilization is larger than warn threshold | COUNT(BYDB_DATA_USED_SIZE_PCT > BYDS_DATA_USED_SIZE_WARN_THRESHOLD) |
Days to Saturation | Number of days before the tablespace utilization will breach the thresholds |
This is a screenshot of the page:
Database Instance - Detail page
Database instance detail page shows detailed information and its tablespaces as sub resources.
The following charts representing some metrics from each database instance:
- Database Space Used (DB_TOTAL_USED_SIZE)
- Table Space Utilization (BYDS_DATA_USED_SIZE_PCT)
The Tablespaces table represents table space as each sub resources, and each column is listed as the following:
Column Name | Description | Source Metrics or Calculation |
|---|---|---|
Tablespace Name | Name of tablespace | BYDS_NAME |
DB Name | Name of the database instance | DB_NAME |
DS Data Allocated Size [GB] | Space allocated by the datastore specified in the tablespaces | BYDS_DATA_ALLOCATED_SIZE [95th] |
DS Data Used Size [GB] | Space used by the datastore specified in the tablespaces | BYDS_DATA_USED_SIZE [95th] |
DS Data Used Size % [%] | Space utilization percentage for the datastore specified in the | BYDS_DATA_USED_SIZE_PCT [95th] |
This is a screenshot of the page:
