Database Load Hourly

Hourly summary of the CPU and IO metrics collected at the database instance.

Table 16-10 Database CPU and IO 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 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
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 Name of the container for the database
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
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 (hourly) background CPU usage (secs/sec) NUMBER METRIC Maximum (hourly) 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 (hourly) CPU utilization (%) NUMBER METRIC Maximum (hourly) 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 (hourly) write IO per second (MB/sec) NUMBER METRIC Maximum (hourly) 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 (hourly) read IO per second (MB/sec) NUMBER METRIC Maximum (hourly) 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 (hourly) number of IO (in megabytes) per second to and from the deployed database instance
ROLLBACKS_PER_SECOND Rollbacks per second NUMBER METRIC Number of times per second, that users manually issue the ROLLBACK statement or an error occurred during a user's transactions
ROLLBACKS_PER_SECOND_MAX Maximum (hourly) rollbacks per second NUMBER METRIC Maximum (hourly) number of times per second, that users manually issue the ROLLBACK statement or an error occurred during a user's transactions
EXECUTIONS_COUNT SQL execution count NUMBER METRIC Total number of calls (user and recursive) that execute SQL statements
TRANSACTIONS_COUNT Commits and rollbacks count NUMBER METRIC Total number of commits and rollbacks performed
HARD_PARSES Hard parses per second NUMBER METRIC Number of hard parses per second
HARD_PARSES_MAX Maximum (hourly) hard parses per second NUMBER METRIC Maximum (hourly) number of hard parses per second
SOFT_PARSES Soft parses per second NUMBER METRIC Number of soft parses per second
SOFT_PARSES_MAX Maximum (hourly) soft parses per second NUMBER METRIC Maximum (hourly) number of soft parses per second