Database Tablespace Daily

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

Table 16-9 Database Tablespace 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
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 (daily) used tablespace (GB) NUMBER METRIC Maximum (daily) 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 (daily) storage utilization (GB) NUMBER METRIC Maximum (daily) percentage of the space used for the tablespace