Skip to main content
Skip table of contents

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

Log on to Germain Workspace > left menu > Wizards > Oracle Database Server

Oracle Database Server Wizard - Germain UX

Add Database as Data Source

Germain workspace > Left Menu > Data Sources > Database > Add New Configuration

Add Oracle Database as Data Source - Germain UX

Add DB Credentials

Germain Workspace > Left Menu > Data Sources > Credentials

Add Oracle Database Credentials for Oracle- Germain UX

Add Database Query Monitor

Germain Workspace > Left Menu > Wizards > Database Query Monitor Deployment

Add Oracle Database Query Monitor for Oracle - Germain UX

Enter Database details

Enter Oracle Database Details - Germain UX

Add Oracle database Query Monitor - Germain UX

Oracle Database Query Monitor - Germain UX

Add Oracle Database Query Monitor Component - Germain UX

Add KPI

Add KPI for your Oracle database- Germain UX

Add KPI for Oracle - Germain UX

Create the base SLA for the new KPI. Choose Fact-based SLA

Add SLA for Oracle - Germain UX

Add SLA

Alert Template: SLA.
Choose one or more of your actions (Alerts, Reports, Scripts, ect..)

Add SLA Alert Template - Germain UX

Set KPI

Configure KPI for Oracle - Germain UX

Add SLA Threshold for Oracle - Germain UX

Deployment details

Monitoring Node: The Node that the Engine runs from

Engine: The engine you want to run the Monitor on

Fill in the schedule you would like the Monitor to run on

Deploy Database Query Monitor for Oracle - Germain UX

Verify the Monitor by finding in “Germain State”

Check Running State of Database Query Monitor

For more detailed information, please reaching out to us. We will provide you with further guidance and assistance tailored to your needs.

 

Component: Engine

Feature Availability: 8.6.0 or later

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.