Database Memory Hourly

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

Table 17-11 Database Memory 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 Exadata insight resource display name (if applicable)
EXADATA_ID Exadata insight resource ID VARCHAR2 DIMENSION ID of the Exadata system to which the database is attached (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
HOST_NAME Host name VARCHAR2 DIMENSION Name of the host on which the database instance is deployed
INSTANCE_NAME Deployed Database instance name VARCHAR2 DIMENSION Name of the deployed database instance
MEMORY_TYPE Type of memory structure VARCHAR2 DIMENSION Memory structure associated with the database with available types: SGA or PGA
MEMORY_POOL Memory pool name VARCHAR2 DIMENSION Name of the memory pool with available types: AllocatedPGA or SharedPool
MEMORY_USAGE Instance memory usage (GB) NUMBER METRIC Memory used by the deployed database instance
MEMORY_USAGE_MAX Maximum (hourly) instance memory usage (GB) NUMBER METRIC Maximum (hourly) memory used by the deployed database instance
MEMORY_UTIL Instance memory utilization (%) NUMBER METRIC Memory utilized by the deployed database instance on the host
MEMORY_UTIL_MAX Maximum (hourly) instance memory utilization (%) NUMBER METRIC Maximum (hourly) memory utilized by the deployed database instance on the host
MEMORY_ALLOCATED Host memory capacity (GB) NUMBER DIMENSION Total memory (in gigabytes) allocated to the host