Enterprise and Database Monitoring Features

Try OCI for free

Key features

Enterprise-class monitoring

Out-of-the-box monitoring

After target discovery, automatic monitoring of status and performance, including auto-generation of incidents for target down and other critical conditions.

Advanced threshold management

In addition to static thresholds, alert thresholds can auto-adjust to workloads via Time-Based Static Thresholds or Adaptive Thresholds.

  • Time-Based Static Thresholds are defined threshold values used at different times of the day and/or week to account for changing workload conditions. For example, if there are heavier workloads during the weekday versus the weekend, set higher thresholds for the weekday and lower thresholds for the weekend.
  • Adaptive Thresholds are statistically computed thresholds that adapt to target workload conditions. These thresholds can be calculated based on baseline windows, the period of time for typical behavior of the target. For example, a warning threshold can be 90% of the maximum value observed during the baseline window and a critical threshold can be 110% of the maximum value observed during the baseline window.

Custom metrics

Metric Extensions enable monitoring of conditions specific to your environment.

  • Full development and test lifecycle of Metric Extensions: develop, test, publish.
  • Supports OS Commands, SQL, SNMP, and JMX metric collection methods.
  • Deploy Metric Extensions to individual targets or in bulk to many targets using Monitoring Templates.
  • Import/export Metric Extensions between Enterprise Manager sites.

Auto-resolve alerts

Corrective Actions are scripts that are automatically executed when an alert triggers and can be used to auto-resolve alerts.

  • Out-of-the-box Corrective Actions for common alerts, such as database and listener down and tablespace full.
  • Full development and test lifecycle of custom Corrective Actions: create, test, publish.
  • Deploy Corrective Actions to your fleet of targets as part of Monitoring Templates.
  • Receive notifications for the success or failure of Corrective Actions.

Automate threshold management

Simplified and automated application of monitoring settings across your fleet using Monitoring Templates and Administration Groups.

  • Use Monitoring Templates to contain common monitoring settings for targets. For example, you can have one for production targets and one for test targets.
  • Use Administration Groups to organize targets with common monitoring settings (such as Prod Group and Test Group) and associate Monitoring Templates with the Administration Groups to auto-apply monitoring settings.

Maintenance periods

Blackouts temporarily suspend unwanted alerts during planned maintenance windows.

  • Use Blackouts to suspend monitoring and alerting on targets in order to perform maintenance operations.
  • Use Notification Blackouts to continue alerting but suspend alert notifications during maintenance windows.

24/7 monitoring

Continuous and uninterrupted monitoring during unplanned and planned Enterprise Manager downtime.

  • Use Zero Downtime Monitoring in Enterprise Manager 24ai to ensure continuous monitoring of targets via alerts, incident, notifications, and tickets with external systems during planned downtime of Enterprise Manager.
  • Use Always-On Monitoring to send email notifications for critical alerts during planned downtime of Enterprise Manager 13.5.

Oracle Database monitoring

Discovery of Oracle Database

Discover all components of an Oracle Database system, including RAC database, pluggable databases, listener, and ASM.

  • Use auto-discovery to automatically find all databases that are not yet monitored.
  • Use guided discovery to find databases running on a specified host.
  • Use manual discovery to explicitly specify monitoring properties to discover the database.

Comprehensive database monitoring

Extensive monitoring for RAC database, database instance, pluggable databases, listener, and ASM with more than 500 metrics.

  • More than 500 metrics for status, load, performance and more.
  • View of heavily loaded databases across your fleet.
  • Easy-to-use drilldown into individual database homepages for views on resource consumption, longest running SQLs, and critical incidents.
  • Corrective Actions to auto-resolve alerts for database down, tablespace full, and listener down.
  • Jobs to back up database and to automate password changes for Oracle and ASM databases monitoring and non-monitoring users.

MySQL monitoring

Discovery of MySQL database

Automated discovery of MySQL databases

  • Use auto-discovery to automatically find MySQL databases that are not yet monitored.
  • Use manual discovery to manually specify MySQL database, InnoDB cluster, and InnoDB ClusterSet details for discovery.

Comprehensive monitoring for MySQL

Extensive monitoring for MySQL instance and InnoDB Cluster/ClusterSet with more than 600 metrics.

  • More than 600 metrics for status, database activity, replication activity, and more.
  • View group replication details for an InnoDB Cluster in a singular view.
  • Customize metric thresholds for alerting and apply across a fleet using Monitoring Templates.
  • Corrective Actions to auto-resolve alerts for database down.
  • Homepage to view availability history over the last 24 hours and monitor key performance metrics, such as connections to MySQL and InnoDB buffer pool usage, and track critical incidents.
  • Jobs to backup database and purge binary logs.

Identification of poor-performing queries

Query Analyzer enables DBAs to run explain plans to better identify and triage poor-performing queries.

  • Filters to view the top 100 worst performing queries based on highest executions or top latencies or first time seen.
  • Access to historical queries to understand performance over time.
  • Explain plans to identify performance bottlenecks of your queries.
  • Graphs to view any unusual spikes in average execution time, execution count, and rows affected.

Safeguard MySQL databases

Expert recommendations to ensure compliance against replication and InnoDB configuration and other best practices.

  • Out-of-the-box standards to evaluate compliance against best practices for performance, replication, security, schema, and administration.
  • Use the Compliance Dashboard to track compliance violations across a fleet of MySQL databases
  • View the Evaluation Report for a list of each compliance violation and its remediation process.

SQL Server and IBM DB2 monitoring

Discovery of databases

Use manual discover to manually specify monitoring properties to discover SQL Server and IBM DB2 databases for immediate monitoring.

Comprehensive monitoring for SQL Server

Extensive monitoring for SQL Server with more than 450 metrics.

  • More than 450 SQL Server metrics to monitor for query performance, status, and health of High Availability Disaster Recovery (HADR) replicas and more.
  • Customize metric thresholds for alerting and apply across a fleet using Monitoring Templates.
  • Homepage to ensure all the databases on the SQL Server instance are online. View the top processes overly working the CPU and track critical incidents that need immediate attention.
  • Jobs to start/stop SQL Server Agent, backup SQL Server database, and kill session.

Comprehensive monitoring for IBM DB2

Extensive monitoring for IBM DB2 with more than 460 metrics.

  • More than 460 IBM DB2 metrics to monitor for query performance, High Availability Disaster Recovery (HADR) cluster status, and more.
  • Customize metric thresholds for alerting and apply across a fleet using Monitoring Templates.
  • Homepage to monitor key performance indicators, such as tablespace utilization, view CPU utilization across applications, and track critical incidents that need immediate attention.
  • Jobs to startup/shutdown DB2, quiesce/unquiesce DB2 during maintenance modes, and kill DB2 application.

Safeguard SQL Server databases

Expert recommendations to ensure SQL Server compliance with configuration best practices.

  • Out-of-the-box standard to evaluate configuration compliance for database backup frequency, correcting index fragmentation, and more.
  • Use the Compliance Dashboard to track compliance violations across a fleet of SQL Server databases.
  • View the Evaluation Report for a list of each compliance violation and its remediation process.

Incident management and notifications

Incident creation and notification

Create incidents for actionable events and send notifications.

  • Use Incident Rules to create incidents for actionable events, send notifications, and open tickets.
  • Notify via email, Slack, Webhooks, SNMP Traps, or OS Commands.
  • Share events or incidents with ServiceNow, PagerDuty, Jira, Microsoft SCOM, and IBM Tivoli Netcool/OMNIbus.

Event Compression

Event Compression reduces incident volume by automatically compressing, or grouping, related events into a smaller number of incidents.

  • Use out-of-the-box Event Compression policies for common event compression scenarios.
  • Create custom policies for unique compression requirements.
  • Use Event Compression Analysis to test the efficiency of policies against your own events.

Incident Manager

Incident Manager provides centralized management of incidents.

  • Use Incident Manager to assign and track incident status and use Dynamic Runbooks to resolve incidents.
  • Use the Incident Dashboard for a summary of the incident backlog, helping assess incidents by severity, longest running incidents, and problem areas (such as unassigned incidents).

Dynamic Runbooks

Dynamic Runbooks contain best practice procedures to triage and resolve issues such as incidents, problem jobs, and more.

  • Use dynamic runbooks in context of incidents, metrics, and any other functional area in Enterprise Manager.
  • Create Dynamic Runbooks using different step types: Notes, Metric Charts, Repository SQL, Target SQL, or OS Command.
  • Use Oracle-provided Dynamic Runbooks to triage and resolve Enterprise Manager infrastructure issues.