Database Tablespace Hourly
Hourly summary of the tablespace metrics collected at the database instance.
Table 17-15 Database Tablespace Hourly
| Field Name | 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 |
| 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) |
| VMCLUSTER_ID | Exadata VM cluster ID | VARCHAR2 | DIMENSION | Exadata VM cluster ID (if applicable) |
| VMCLUSTER_NAME | Exadata VM cluster name | VARCHAR2 | DIMENSION | Exadata VM cluster ID (if applicable) |
| ASSOCIATED_RESOURCE_ID | Associated resource identifier | VARCHAR2 | DIMENSION | OCID of the related OCI resource |
| SOURCE_IDENTIFIER | Telemetry source identifier | VARCHAR2 | DIMENSION | Enterprise Manager GUID or Management Agent OCID (identifier for where the telemetry is being collected) |
| SOURCE_ENTITY_IDENTIFIER | Telemetry source entity identifier | VARCHAR2 | DIMENSION | Enterprise Manager target GUID |
| DB_NAME | Database Name | VARCHAR2 | DIMENSION | Name of the database |
| DB_DISPLAY_NAME | Database display name | VARCHAR2 | DIMENSION | Display name of the database |
| CDB_NAME | CDB name | VARCHAR2 | DIMENSION | CDB name |
| DB_VERSION | Database version | VARCHAR2 | DIMENSION | Version of the database |
| TABLESPACE_NAME | Tablespace name | VARCHAR2 | DIMENSION | Storage tablespace name |
| TABLESPACE_CONTENT | Tablespace content | VARCHAR2 | DIMENSION | Storage tablespace content |
| SPACE_USED | Used tablespace (GB) | NUMBER | METRIC | Space used from the allocated for the tablespace on disk |
| SPACE_USED_MAX | Maximum (hourly) used tablespace (GB) | NUMBER | METRIC | Maximum (hourly) space used from the allocated for the tablespace on disk |
| SPACE_ALLOCATED | Allocated storage space | NUMBER | DIMENSION | Space allocated for the tablespace on disk |
| STORAGE_UTILIZATION | Storage utilization (GB) | NUMBER | METRIC | Percentage of the space used for the tablespace |
| STORAGE_UTILIZATION_MAX | Maximum (hourly) storage utilization (GB) | NUMBER | METRIC | Maximum (hourly) percentage of the space used for the tablespace |