> ## Documentation Index > Fetch the complete documentation index at: https://docs.germainux.com/llms.txt > Use this file to discover all available pages before exploring further. # Oracle DB Observability > GermainUX provides real-time Observability, Performance Monitoring, Analytics, Alerting, and Automation for Oracle Database. Components [`Engine`](https://docs.germainux.com/main/germain-ux-engine) Availability 2014.1 or later > [card] [Database Availability](#database-availability) > > Instance and cluster uptime > [card] [Open & Active Cursors](#open-&-active-cursors) > > Cursor usage on Oracle > [card] [Preconfigured Oracle Database KPIs](#preconfigured-oracle-database-kpis) > > Built-in metrics ready to use > [card] [Deployment](#deployment) > > Setup through a wizard ## Overview GermainUX provides real-time **Observability, Performance Monitoring, Analytics, Alerting, and Automation for Oracle Database**. Monitor database availability, SQL performance, sessions, locks, connections, tablespaces, datafiles, redo and archive logs, backups, errors, and supporting infrastructure. GermainUX provides visibility across: Application SQL Query Oracle Database Instance / RAC Infrastructure ## Database Availability Continuously monitor Oracle Database availability and connectivity. GermainUX helps teams: * Monitor database uptime * Detect connectivity issues * Identify database availability problems * Track availability over time * Alert when the database becomes unavailable For Oracle RAC environments, monitoring can cover the cluster or individual instances. ## Database Performance Monitor key Oracle Database performance metrics to identify bottlenecks and resource constraints. Analyze metrics associated with: * CPU * Memory * Disk I/O * Network * Database activity * Resource utilization Historical analytics help identify recurring performance degradation and capacity trends. ## SQL Query Performance Monitor SQL executed against Oracle Database. Analyze: * Query response time * SQL execution * Execution plans * Index usage * Slow-running queries Query telemetry helps identify database operations contributing to application performance degradation. ## Sessions & Locks Monitor active Oracle sessions and database locking conditions. GermainUX can help identify: * Active sessions * Long-running sessions * Blocked sessions * Locked objects * Lock contention * Database deadlocks This helps teams identify concurrency conditions affecting application transactions and database performance. ## Database Connections Monitor Oracle Database connection activity and utilization. Identify conditions such as: * Excessive connections * Unexpected connection growth * Connection utilization * Potential connection leaks Connection monitoring helps identify application or database conditions affecting scalability and performance. ## Open & Active Cursors Monitor Oracle cursor activity. GermainUX provides KPIs for: * Database Open Cursor Count * Database Active Cursors Cursor monitoring can help identify application or database behavior contributing to excessive resource utilization. ## Tablespaces & Datafiles Monitor Oracle tablespace and datafile capacity. Analyze: * Tablespace utilization * Temporary space * Available capacity * Database size * Datafile usage * Storage growth Proactive monitoring helps identify space-related conditions before they affect database availability or application processing. ## Redo Log & Archive Log Monitoring Monitor Oracle redo-log and archive-log activity. GermainUX can help teams analyze: * Redo-log activity * Redo-log utilization * Archive-log activity * Recovery-area conditions * Log-space utilization This provides visibility into database activity related to transaction durability and recovery. ## Backup & Recovery Monitor Oracle backup and recovery processes. Analyze: * Backup execution * Backup completion * Backup failures * Recovery activity * Recovery time This helps identify failed or incomplete backup activity before it becomes a recovery risk. ## Database Errors & Alerts Monitor Oracle Database errors, warnings, and diagnostic information. GermainUX can identify and analyze: * Database errors * Warnings * Informational events * Recurring database conditions * Diagnostic alerts Error telemetry can be correlated with SQL, session, resource, and application telemetry to accelerate troubleshooting. ## Oracle RAC Monitoring For Oracle Real Application Clusters (RAC), GermainUX supports monitoring Oracle telemetry using the corresponding global `GV$` system views. This enables monitoring across multiple Oracle instances rather than limiting analysis to a single database instance. Monitoring can be configured according to whether visibility is required at: * Cluster level * Individual instance level * Both ## Preconfigured Oracle Database KPIs GermainUX provides Oracle Database KPIs including: * Database Deadlocks * Database Table Locks * Database Errors * Database Temp Space * Database Logspace Utilization * Database Size > [accordion] Show all 9 > > * Database Tablespace Utilization > * Database Open Cursor Count > * Database Active Cursors Additional KPIs can be created according to the requirements of the Oracle environment. ## Custom Oracle Query Monitoring GermainUX can execute configurable SQL against Oracle Database. This allows monitoring to extend beyond preconfigured Oracle metrics. Custom Query Monitors can access permitted: * Oracle system views * DBA views * Application tables * Business data * Operational data This allows organizations to create application-specific database monitoring using the same GermainUX analytics and automation capabilities. ## Detect Oracle Database Issues GermainUX can detect conditions such as: * Database unavailable * Slow SQL * Blocked sessions * Deadlocks * Table locks * Excessive connections > [accordion] Show all 13 > > * Cursor growth > * Tablespace capacity issues > * Temporary-space issues > * Redo/archive-log conditions > * Database errors > * Backup failures > * Custom database conditions Detected conditions can be analyzed, alerted on, reported, or used to trigger automated actions. ## Real-Time Dashboards & Automated Reports Create dashboards and automated reports for Oracle Database telemetry. Examples include: * Database availability * Performance * SQL performance * Sessions and locks * Connections * Cursors > [accordion] Show all 13 > > * Tablespaces > * Database size > * Redo/archive logs > * Errors > * Backup status > * RAC instances > * Custom database KPIs Combine Oracle telemetry with application and infrastructure monitoring where broader operational context is required. ## Alerts & SLA Monitoring Configure SLAs and alerts for Oracle Database conditions requiring attention. For example: * Database unavailable * Query response time exceeds threshold * Deadlock detected * Blocked session detected * Tablespace utilization exceeds threshold * Temporary space exceeds threshold > [accordion] Show all 9 > > * Excessive connections > * Database error detected > * Backup failure Fact-based SLAs can trigger configured GermainUX actions. ## Automation Oracle Database conditions can trigger GermainUX automation. For example: Monitor Detect Analyze Alert Automate Depending on the use case, automation can include: * Notifications * Reports * Scripts * Operational workflows * Remediation actions where appropriate ## Correlate Oracle with Applications & Infrastructure Oracle Database telemetry can be combined with other technologies monitored by GermainUX. For example: User / Application Transaction SQL Query Oracle Database Infrastructure For RAC: Application SQL Query Oracle RAC Instance Infrastructure This helps teams determine whether degradation originates in the application, SQL, database instance, RAC environment, or supporting infrastructure. ## Deployment Oracle Database monitoring is executed by the **GermainUX Engine**. GermainUX provides an **Oracle Database Server Wizard** to help deploy Oracle monitoring. See **Deploy Monitoring for Oracle Database** for deployment instructions. ## Get Help > [card] [Contact GermainUX Support](https://docs.germainux.com/main/support.md) > > The GermainUX team helps you get up and running faster, empower your team, turn data into actionable insights, and optimize performance to deliver measurable business outcomes. > [card] Can't find what you need? > > Search all GermainUX docs with **Ctrl + K**, or use the feedback buttons at the bottom of this page to tell us what is missing. The content of this document is proprietary to GERMAIN SOFTWARE. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.