Database Memory Daily
Daily summary of the memory metrics collected at the database instance.
Table 16-7 Database Memory 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 | Exadata VM cluster ID (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 name (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 (daily) instance memory usage (GB) | NUMBER | METRIC | Maximum (daily) 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 (daily) instance memory utilization (%) | NUMBER | METRIC | Maximum (daily) 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 |