Oracle DB Monitoring

Feature

Germain monitors the uptime and performance of Oracle database servers.

Backup and recovery

Monitor the backup and recovery processes of the Oracle database. Ensure that regular backups are performed successfully and monitor the backup completion status. Track recovery times in case of any database failures or data corruption.

Database connections

Monitor the number of active database connections and track connection usage. Identify any connection leaks or excessive connections that could impact the performance and scalability of the database.

Error logs and alerts

Monitor Oracle database error logs and alerts to identify and resolve any issues or errors that occur within the database. Log and track error messages, warnings, and informational events for troubleshooting and proactive maintenance.

Performance metrics

Monitor key performance metrics of the Oracle database, including CPU usage, memory utilization, disk I/O, and network traffic. These metrics help identify any performance bottlenecks or resource constraints that could impact the database's performance.

Query performance

Monitor the performance of SQL queries executed against the Oracle database. Track metrics such as query response time, execution plans, and index usage. Identify slow-running queries and optimize their performance to improve overall database efficiency.

Redo log and archive log activity

Monitor the activity and size of redo logs and archive logs. Ensure that the redo log files are sized appropriately and that archiving is happening correctly. This helps ensure data integrity and recovery capabilities.

Server availability

Monitor the availability of the Oracle database server to ensure it is up and running. Track uptime and receive alerts if the server goes down or experiences any connectivity issues.

Sessions and locks

Monitor the number of active sessions and track their activity within the Oracle database. Identify long-running or blocked sessions, as well as any lock contention issues that can affect database performance.

Tablespaces and datafiles

Configuration

Monitor the usage and growth of tablespaces and datafiles within the Oracle database. Track free space, growth rate, and ensure that tablespaces are properly managed to prevent space-related issues.

For basic monitoring of a single instance, Germain uses a regular database user account with CONNECT permissions. In the case of Oracle RAC, it is possible to monitor the status of the cluster as a whole or individual instances. To perform more in-depth monitoring, the database user needs to be granted additional permissions to execute queries against a series of system views.

Please note that Germain can monitor any other Oracle tables, whether they are system tables or data tables. The requirements mentioned below are the bare minimum, but they can be extended to include monitoring of any other tables as well.

Table / View	Permission
V$SYSSTAT	SELECT
V$SYSTEM_EVENT	SELECT
V$SESSION	SELECT
V$SQL	SELECT
V$SQLTEXT	SELECT
V$SYSTEM_PARAMETER	SELECT
V$RESOURCE_LIMIT	SELECT
V$SQLSTATS	SELECT
V$SESSTAT	SELECT
V$STATNAME	SELECT