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 attributed total cost |
| ATTRIBUTED_TOTAL_COST_SUM | Attributed total cost SUM | NUMBER | METRIC | Total attributed total cost |
| ATTRIBUTED_USED_COST_AVG | Attributed Used cost AVG | NUMBER | METRIC | Average attributed used cost |
| 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 |
| ATTRIBUTED_UNUSED_COST_SUM | Attributed Unused cost SUM | NUMBER | METRIC | Total attributed unused cost |
| 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 |
| BILLED_RESOURCE_CAPACITY_MAX | Maximum (Daily) Billed resource Capacity | NUMBER | METRIC | Maximum (daily) billed resource capacity for the Exadata infrastructure |
| BILLED_RESOURCE_CAPACITY_MEDIAN | Median (Daily) Billed resource Capacity | NUMBER | METRIC | Median (daily) billed resource capacity for the Exadata infrastructure |
| 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 |