dbXplorer - ASH Monitoring sql_id related logs view
dbXplorer - DB Performance Health
dbXplorer - Space Monitoring
dbXplorer - Status Summary
Overview
dbXplorer enables you to monitor Oracle (19c or later) databases, providing you with real-time analytics and performance metrics available in Datadog. This integration gives deep visibility into the health and performance of your Oracle database instances.
With this integration:
Proactively Monitor: Detect potential issues early through real-time alerts on performance bottlenecks, unusual activities, or failures.
Optimize Performance: Gather insights into database performance to help tune queries and resources, ensuring optimal utilization and response times.
Simplified Management: Centralize monitoring of multiple Oracle databases into a single platform, streamlining the management process and reducing operational overhead.
This integration monitors the following types of data from Oracle databases:
Performance Metrics: Includes data on query response times, memory usage (for example, PGA and SGA statistics), and resource bottlenecks. This data helps in identifying performance issues and optimizing database operations.
Health Metrics: Tracks critical health indicators such as connection times, user sessions, and system availability, enabling timely intervention to prevent downtimes.
About ITUnified: with more than two decades of expertise, their Oracle-certified database Administrator (DBA) professionals are equipped with the skills required to handle intricate projects and support clients in managing and administering their databases. ITUnified specializes in tailored database support and services through a detailed needs assessment.
Metrics
The dbXplorer integration collects 77 metrics in 8 different categories.
11 metrics based on Oracle’s internal DBA_HIST_ACTIVE_SESS_HISTORY table. It provides values for previous and repeated SQL queries.
28 metrics based on Oracle’s internal DBA_HIST_SQLSTAT table providing application, CPU, disk read and writes, I/O, concurrency wait times for SQL queries.
11 metrics based on Oracle’s internal V$OSSTAT table. This table contains system utilization statistics from the operating system.
2 metrics are retrieved from the V$SESSION_EVENT table and display information on waits for an event by a session.
10 metrics are retrieved from the v$system_event table and display information on total waits for an event.
1 metric contains statistic names. The different statistic names are described [here] 2.
5 metrics related to the database recovery area.
8 metrics related to tablespace usage.
Monitors
With 12 included monitors, get notified with:
Anomaly detection for SQL executions based on CPU and elapsed times.
Database health alerts for load and wait events
General database availability
Predictive alerts for tablespace usage of undo, temporary and permanent tablespaces
Predictive alerts for recovery area usage
Predictive alerts for ASM disk usage
Dashboards
The dbXplorer integration contains 4 dashboards:
dbXplorer - ASH Monitoring
The “dbXplorer - ASH Monitoring” dashboard is designed to provide a comprehensive performance analysis of Oracle Databases, leveraging SQLSTAT and ACTIVE SESSION HISTORY (ASH) data. The dashboard combines SQL execution metrics from SQLSTAT with session-level activity insights from ASH, enabling a holistic view of database performance and opportunities for optimization. It features multiple widgets including detailed timeseries graphs and query tables that monitor and analyze various performance metrics such as elapsed time, CPU time, and I/O operations. Key features include anomaly detection for specific SQL identifiers, historical performance analysis, and trend monitoring to diagnose performance issues and optimize database operations.
dbXplorer - DB Performance Health
The “dbXplorer - DB Performance Health” dashboard is tailored for comprehensive monitoring of Oracle Database performance, focusing on various critical aspects such as load anomalies, session wait anomalies, CPU usage, and memory usage. It employs multiple widgets that visually display data using graphs and tables, helping database administrators quickly identify and address performance bottlenecks. Key features include detailed analysis of session wait events through the v$session_event and v$session_wait views, which offer insights into specific wait events and their impact on database sessions. Additionally, the dashboard provides tools to monitor and analyze system-wide performance metrics via the v$system_event and v$osstat views, covering system-level waits and operating system interactions that affect database operations.
dbXplorer - Space Monitoring
The “dbXplorer - Space Monitoring” dashboard provides detailed monitoring and forecasting for Oracle database tablespaces, recovery areas, and Automatic Storage Management (ASM) disk groups. It enables visualization of current and historical data usage, alerts for critical thresholds, and trends in space allocation over various time frames. Widgets within the dashboard include timeseries graphs, query tables, and status summaries that allow users to track metrics like total, used, and available space efficiently. Additionally, the dashboard offers dynamic filtering options through template variables, making it highly customizable for specific database instances or clusters. This tool is essential for database administrators aiming to maintain optimal performance and preempt potential space-related issues in their systems.
dbXplorer - Status Summary
The “dbXplorer - Status Summary” dashboard provides a concise view of status and logs for database operations. It features “Availability Logs” that display events related to database availability, sorted by various parameters such as timestamp and instance name. Another widget, “dbXplorer Logs,” organizes log data from database transactions into a summarized view, grouping by logger name and showing counts of logs by severity. The “Status Summary” widget offers an overview of statuses in a list and count format, prioritizing the data display based on the severity of issues.
dbXplorer - Oracle LMS
The “dbXplorer - Oracle LMS” dashboard focuses on Oracle License Management Services (LMS), and tracks and reports on the usage of database features that are relevant for licensing. It features a visualization of CPU count which helps in understanding the scale of database operations and the potential licensing needs. Additionally, the dashboard includes detailed feature usage statistics, which executes complex queries to map database features to products, classifying the usage into categories like current and past usage, and managing exceptions in feature reporting. While this dashboard is an essential tool for database administrators to ensure compliance with Oracle licensing requirements it should not be relied on exclusively for licensing purposes.
Prerequisites
Oracle database versions from 19c EE using Oracle Grid Infrastructure are supported. Collection from earlier database versions or serverless installations are not supported.
This integration requires an Oracle Diagnostic and Tuning Pack license. If you do not wish to use or license this pack, be sure to disable the collection of ASH and AWR metrics. An explanation of how to collect or disable these metrics can be found in the setup instructions.
