Exadata Chargeback Cost - Daily
This data object provides a daily summary of chargeback costs attributed at the PDB and non-CDB level.
Table 17-26 Exadata Chargeback Cost - Daily
| Field Name | Name | Column Type | Column Category | Description |
|---|---|---|---|---|
| ROLLUP_TIME_UTC | Rollup time (UTC) | TIMESTAMP | TIME_DIMENSION | End timestamp of the rollup period (UTC) |
| DAY_OF_WEEK | Collection day of week | VARCHAR2 | DIMENSION | Collection day in weekly range 1-7 (Mon-Sun) |
| DAY_OF_MONTH | Collection day of month | VARCHAR2 | DIMENSION | Collection day in monthly range 1-31 |
| 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 day |
| BILLED_COST_SUM | Billed Cost SUM | NUMBER | METRIC | Total billed cost for the day |
| ATTRIBUTED_TOTAL_COST_AVG | Attributed total cost AVG | NUMBER | METRIC | Average (daily) attributed total cost calculated for the day for attributed cost type and chargeback plan type. For CPU attributed cost type and weighted allocation plan type, total cost per hour is allocated proportionally based on each database's share of the total VM cluster CPU utilized during that hour. |
| ATTRIBUTED_TOTAL_COST_SUM | Attributed total cost SUM | NUMBER | METRIC | Attributed total cost calculated for the day for attributed cost type and chargeback plan type. For CPU attributed cost type and weighted allocation plan type, total cost per hour is allocated proportionally based on each database's share of the total VM cluster CPU utilized during that hour. |
| ATTRIBUTED_USED_COST_AVG | Attributed Used cost AVG | NUMBER | METRIC | Average (hourly) attributed used cost calculated for the day for attributed cost type. For CPU attributed cost type, the used cost per hour is allocated based on the database's CPU usage relative to the VM cluster CPU capacity during that hour. |
| ATTRIBUTED_USED_COST_SUM | Attributed Used cost SUM | NUMBER | METRIC | Attributed used cost calculated for the day for attributed cost type. For CPU attributed cost type, the used cost per hour is allocated based on the database's CPU usage relative to the VM cluster CPU capacity during that hour. |
| ATTRIBUTED_UNUSED_COST_AVG | Attributed Unused cost AVG | NUMBER | METRIC | Average (daily) attributed unused cost calculated for the day for attributed cost type and chargeback plan type. For CPU attributed cost type and weighted allocation plan type, unused cost per hour is allocated proportionally based on each database's share of the total VM cluster CPU utilized during that hour. |
| ATTRIBUTED_UNUSED_COST_SUM | Attributed Unused cost SUM | NUMBER | METRIC | Total attributed unused cost calculated for the day for attributed cost type and chargeback plan type. For CPU attributed cost type and weighted allocation plan type, unused cost per hour is allocated proportionally based on each database's share of the total VM cluster CPU utilized during that hour. |
| USAGE_AVG | Usage related to Attributed cost type | NUMBER | METRIC | Average (daily) usage related to attributed cost type, for example, average rate of CPU time usage |
| USAGE_MAX | Maximum (Daily) Usage related to Attributed cost type | NUMBER | METRIC | Maximum (daily) usage related to attributed cost type |
| USAGE_MEDIAN | Median (Daily) Usage related to Attributed cost type | NUMBER | METRIC | Median (daily) usage |
| VMCLUSTER_UTILIZATION_AVG | VM Cluster utilization (%) | NUMBER | METRIC | Average (daily) percentage of usage related to attributed cost type. For CPU attributed cost type, it is average (daily) percentage of total CPU time spent by the database. |
| VMCLUSTER_UTILIZATION_MAX | Maximum (Daily) VM Cluster utilization (%) | NUMBER | METRIC | Maximum (daily) percentage of usage related to attributed cost type. For CPU attributed cost type, it is maximum (daily) percentage of total CPU time spent by the database. |
| BILLED_RESOURCE_CAPACITY_AVG | Average (Daily) Billed resource Capacity | NUMBER | METRIC | Average (daily) billed resource capacity for the Exadata infrastructure related to attributed cost type. For CPU attributed cost type, it is the Average (Daily) CPU allocated to the VM cluster. |
| BILLED_RESOURCE_CAPACITY_MAX | Maximum (Daily) Billed resource Capacity | NUMBER | METRIC | Maximum (daily) billed resource capacity for the Exadata infrastructure related to attributed cost type. For CPU attributed cost type, it is the Maximum (Daily) CPU allocated to the VM cluster. |
| BILLED_RESOURCE_CAPACITY_MEDIAN | Median (Daily) Billed resource Capacity | NUMBER | METRIC | Median (daily) billed resource capacity for the Exadata infrastructure related to attributed cost type. For CPU attributed cost type, it is the Median (Daily) CPU allocated to the VM cluster. |
| SAMPLE_COUNT | Sample Count | NUMBER | METRIC | Number of samples used to calculate aggregates |
| 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 |