Database Memory Hourly
Hourly summary of the memory metrics collected at the database instance.
Table 16-9 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 |