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
Add Database as Data Source
Germain workspace > Left Menu > Data Sources > Database > Add New Configuration
Add DB Credentials
Germain Workspace > Left Menu > Data Sources > Credentials
Add Database Query Monitor
Germain Workspace > Left Menu > Wizards > Database Query Monitor Deployment
Enter Database details
Add KPI
Create the base SLA for the new KPI. Choose Fact-based SLA
Add SLA
Alert Template: SLA.
Choose one or more of your actions (Alerts, Reports, Scripts, ect..)
Set KPI
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
Verify the Monitor by finding in “Germain State”
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