Exadata Chargeback Cost - Hourly
This data object provides an hourly summary of chargeback costs attributed at the PDB and non-CDB level.
Table 17-27 Exadata Chargeback Cost - Hourly
| Field Name | Display Name | Column Type | Column Category | Description |
|---|---|---|---|---|
| ROLLUP_TIME_UTC | Rollup time (UTC) | TIMESTAMP | TIME_DIMENSION | End timestamp of the rollup period (UTC) |
| HOUR_OF_DAY | Collection hour of day | VARCHAR2 | DIMENSION | Collection hour in hourly range 0-23 |
| OPSI_ID | Database insight OCID | VARCHAR2 | DIMENSION | Database Insight resource OCID |
| ASSOCIATED_RESOURCE_ID | Associated resource identifier | VARCHAR2 | DIMENSION | OCID of the related OCI resource |
| ROOT_RESOURCE_ID | Exadata insight dbaas resource OCID | VARCHAR2 | DIMENSION | Exadata Insight DBaaS resource OCID |
| EXADATA_NAME | Exadata insight resource name | VARCHAR2 | DIMENSION | Exadata Insight resource name |
| EXADATA_DISPLAY_NAME | Exadata insight resource display name | VARCHAR2 | DIMENSION | Display name of the Exadata system to which the database is attached (if applicable) |
| EXADATA_ID | Exadata insight resource ID | VARCHAR2 | DIMENSION | ID of the Exadata system to which the database is attached (if applicable) |
| EXADATA_TYPE | Exadata insight resource type | VARCHAR2 | DIMENSION | Exadata Insight resource type |
| BILLED_RESOURCE_ID | Billed resource ID | VARCHAR2 | DIMENSION | Billed resource ID |
| BILLED_RESOURCE_NAME | Billed resource display name | VARCHAR2 | DIMENSION | Billed resource display name |
| COST_TYPE | Cost type of the Exadata resource | VARCHAR2 | DIMENSION | Cost type of Exadata resource, for example, VMCLUSTER_COST, INFRASTRUCTURE_COST |
| ATTRIBUTED_COST_TYPE | Attributed Cost type for database | VARCHAR2 | DIMENSION | Attributed cost type for database, for example,CPU, STORAGE |
| DB_NAME | Database Name | VARCHAR2 | DIMENSION | Name of the database |
| DB_DISPLAY_NAME | Database display name | VARCHAR2 | DIMENSION | Display name of the database |
| DB_VERSION | Database version | VARCHAR2 | DIMENSION | Version of the database |
| OPSI_ENTITY_TYPE | Database type | VARCHAR2 | DIMENSION | Database type, for example, COMANAGED-EXACC-PDB, COMANAGED-EXACS-PDB. |
| CDB_NAME | CDB name | VARCHAR2 | DIMENSION | Name of the container for the database |
| CURRENCY | Billed resource price currency | VARCHAR2 | DIMENSION | Billed resource price currency |
| IS_DELETED_DB | Database resource deleted | VARCHAR2 | DIMENSION | Denotes if DB resource is deleted (0 if not deleted or disabled, 1 if deleted or disabled) |
| BILLED_COST_AVG | Billed Cost Avg | NUMBER | METRIC | Average hourly billed cost for the hour |
| BILLED_COST_SUM | Billed Cost SUM | NUMBER | METRIC | Total billed cost for the hour |
| ATTRIBUTED_TOTAL_COST_AVG | Attributed total cost AVG | NUMBER | METRIC | Average hourly attributed total cost |
| ATTRIBUTED_TOTAL_COST_SUM | Attributed total cost SUM | NUMBER | METRIC | Total attributed total cost for the hour |
| ATTRIBUTED_USED_COST_AVG | Attributed Used cost AVG | NUMBER | METRIC | Average attributed used cost for the hour |
| ATTRIBUTED_USED_COST_SUM | Attributed Used cost SUM | NUMBER | METRIC | Total attributed used cost |
| ATTRIBUTED_UNUSED_COST_AVG | Attributed Unused cost AVG | NUMBER | METRIC | Average attributed unused cost for the hour |
| ATTRIBUTED_UNUSED_COST_SUM | Attributed Unused cost SUM | NUMBER | METRIC | Total attributed unused cost for the hour |
| USAGE_AVG | Usage related to Attributed cost type | NUMBER | METRIC | Average (hourly) usage related to attributed cost type. For CPU attributed cost type, it is the average rate of accumulation of CPU time by foreground sessions in the database over the time interval. |
| USAGE_MAX | Maximum (Hourly) Usage related to Attributed cost type | NUMBER | METRIC | Maximum (hourly) usage related to attributed cost type. For CPU attributed cost type, it is the maximum (hourly) average rate of accumulation of CPU time by foreground sessions in the database over the time interval. |
| USAGE_MEDIAN | Median (Hourly) Usage related to Attributed cost type | NUMBER | METRIC | Median (hourly) usage related to attributed cost type. For CPU attributed cost type, it is the median (hourly) average rate of accumulation of CPU time by foreground sessions in the database over the time interval. |
| VMCLUSTER_UTILIZATION_AVG | VM Cluster utilization (%) | NUMBER | METRIC | Average (hourly) percentage of usage related to attributed cost type. For CPU attributed cost type, it is the average (hourly) percentage of total CPU time spent by the database. |
| VMCLUSTER_UTILIZATION_MAX | Maximum (Hourly) VM Cluster utilization (%) | NUMBER | METRIC | Maximum (Hourly) Percentage of usage related to attributed cost type. For CPU attributed cost type, it is the maximum (Hourly) percentage of total CPU time spent by the database. |
| BILLED_RESOURCE_CAPACITY_AVG | Average (Hourly) Billed resource Capacity | NUMBER | METRIC | Average (hourly) billed resource capacity for the Exadata infrastructure |
| BILLED_RESOURCE_CAPACITY_MAX | Maximum (Hourly) Billed resource Capacity | NUMBER | METRIC | Maximum (hourly) billed resource capacity for the Exadata infrastructure |
| BILLED_RESOURCE_CAPACITY_MEDIAN | Median (Hourly) Billed resource Capacity | NUMBER | METRIC | Median (hourly) billed resource capacity for the Exadata infrastructure |
| SKU_PART_NUMBER | SKU part number | VARCHAR2 | DIMENSION | Billed resource SKU part number |
| SKU_NAME | SKU name | VARCHAR2 | DIMENSION | Billed resource SKU name |
| PLAN_ID | Chargeback plan ID | VARCHAR2 | DIMENSION | Chargeback plan ID of the Exadata resource |
| PLAN_NAME | Chargeback plan name | VARCHAR2 | DIMENSION | Chargeback plan name of the Exadata resource |
| PLAN_TYPE | Chargeback plan type | VARCHAR2 | DIMENSION | Chargeback plan type of the Exadata resource |