Database Tablespace Hourly

Hourly summary of the tablespace metrics collected at the database instance.

Table 16-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