- 필수 기능
- 시작하기
- Glossary
- 표준 속성
- Guides
- Agent
- 통합
- 개방형텔레메트리
- 개발자
- API
- Datadog Mobile App
- CoScreen
- Cloudcraft
- 앱 내
- 서비스 관리
- 인프라스트럭처
- 애플리케이션 성능
- APM
- Continuous Profiler
- 스팬 시각화
- 데이터 스트림 모니터링
- 데이터 작업 모니터링
- 디지털 경험
- 소프트웨어 제공
- 보안
- AI Observability
- 로그 관리
- 관리
Supported OS
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:
This integration monitors the following types of data from Oracle databases:
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.
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.
With 12 included monitors, get notified with:
The dbXplorer integration contains 4 dashboards:
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.
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.
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.
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.
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.
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.
For support or feature requests, reach out to support.datadog@itunified.de.
Additional helpful documentation, links, and articles:
This application is made available through the Datadog Marketplace and is supported by a Datadog Technology Partner. To use it, purchase this application in the Marketplace.