Database Summary Daily
Daily summary for CPU, memory, IO and storage metrics, summed over all of the corresponding database's hosts.
Table 17-12 Database CPU and IO 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 ID | 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 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 |
| ENTITY_SOURCE | Entity source | VARCHAR2 | DIMENSION | Source type of the entity, acceptable values are: AUTONOMOUS_DATABASE, MACS_MANAGED_EXTERNAL_DATABASE and EM_MANAGED_EXTERNAL_DATABASE |
| OPSI_ENTITY_TYPE | Database type | VARCHAR2 | DIMENSION | Database type, for example: ADB-S, ATP-D, EXTERNAL-HOST, EXTERNAL-PDB, EXTERNAL-NONCDB |
| DB_NAME | Database Name | VARCHAR2 | DIMENSION | Name of the database |
| DB_DISPLAY_NAME | Database display name | VARCHAR2 | DIMENSION | Display name of the database |
| DB_VERSION | Database version | VARCHAR2 | DIMENSION | Version of the database |
| HOST_NAME | Host names | VARCHAR2 | DIMENSION | List of names of all the hosts running the database's instance |
| INSTANCE_NAME | Deployed Database instances names | VARCHAR2 | DIMENSION | List of names of all the database's instances |
| CPU_TIME | Background CPU usage (secs/sec) | NUMBER | METRIC | Average rate of accumulation of CPU time by foreground sessions in the database over the time interval |
| CPU_TIME_MAX | Maximum (daily) background CPU usage (secs/sec) | NUMBER | METRIC | Maximum (daily) average rate of accumulation of CPU time by foreground sessions in the database over the time interval |
| CPU_CAPACITY | Allocated Host CPUs | NUMBER | DIMENSION | Total number of CPUs on the database instance's host (if applicable) |
| CPU_ALLOCATED | CPUs allocated | NUMBER | DIMENSION | Total number of CPUs allocated to the database instance (if applicable) |
| MAX_CPU_ALLOCATED | Maximum CPUs allocated | NUMBER | DIMENSION | Total number of CPUs allocated to the host for autonomous databases when auto-scaling feature is enabled, only applicable for autonomous databases |
| CPU_AUTO_SCALING | Auto scaling enabled/disabled | VARCHAR2 | DIMENSION | Indicate the auto scaling status (enabled/disabled) for the autonomous database |
| CPU_UTILIZATION | CPU utilization (%) | NUMBER | METRIC | Activity level from CPU, expressed as a percentage of total time |
| CPU_UTILIZATION_MAX | Maximum (daily) CPU utilization (%) | NUMBER | METRIC | Maximum (daily) activity level from CPU, expressed as a percentage of total time |
| WRITE_IO_MBPS | Write IO per second (MB/sec) | NUMBER | METRIC | Number of IO (in megabytes) per second to the deployed database instance |
| WRITE_IO_MBPS_MAX | Maximum (daily) write IO per second (MB/sec) | NUMBER | METRIC | Maximum (daily) number of IO (in megabytes) per second to the deployed database instance |
| READ_IO_MBPS | Read IO per second (MB/sec) | NUMBER | METRIC | Number of IO (in megabytes) per second from the deployed database instance |
| READ_IO_MBPS_MAX | Maximum (daily) read IO per second (MB/sec) | NUMBER | METRIC | Maximum (daily) number of IO (in megabytes) per second from the deployed database instance |
| IO_USAGE | Read and write IO per second (MB/sec) | NUMBER | METRIC | Number of IO (in megabytes) per second to and from the deployed database instance |
| IO_USAGE_MAX | Read and write IO per second (MB/sec) | NUMBER | METRIC | Maximum (daily) number of IO (in megabytes) per second to and from the deployed database instance |
| MEMORY_USAGE | Host memory usage (GB) | NUMBER | METRIC | Memory used across e all the hosts, running the deployed database's instances |
| MEMORY_USAGE_MAX | Maximum (daily) host memory usage (GB) | NUMBER | METRIC | Maximum (daily) memory used across e all the hosts, running the deployed database's instances |
| MEMORY_UTIL | Host memory utilization (%) | NUMBER | METRIC | Memory utilized across all the hosts, running the deployed database's instances |
| MEMORY_UTIL_MAX | Maximum (daily) host memory utilization (%) | NUMBER | METRIC | Maximum (daily) memory utilized across all the hosts, running the deployed database's instances |
| MEMORY_ALLOCATED | Host memory capacity (GB) | NUMBER | DIMENSION | Total memory (in gigabytes) allocated to all the hosts, running the deployed database's instances |
| STORAGE_USAGE | Database storage usage (GB) | NUMBER | METRIC | Storage used (in gigabytes) on the disk |
| STORAGE_USAGE_MAX | Maximum (daily) database storage usage (GB) | NUMBER | METRIC | Maximum (daily) storage used (in gigabytes) on the disk |
| STORAGE_ALLOCATED | Storage allocated to the disk (GB) | NUMBER | DIMENSION | Capacity (in gigabytes) of the storage disk |
| STORAGE_UTIL | Storage space utilization (%) | NUMBER | METRIC | Percent of storage utilized on the disk |
| STORAGE_UTIL_MAX | Maximum (daily) storage space utilization (%) | NUMBER | METRIC | Maximum (daily) percent of storage utilized on the disk |