Oracle DB Monitoring
Feature
Germain monitors Uptime and Performance of Oracle database servers. 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 that of individual instances. In order to perform more in-depth monitoring, the database user needs to be granted additional permissions to execute queries against a series of system views:
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 |
Please note that Germain can monitor any other oracle tables (system or data) i.e. the above requirements are the bare minimum requirements yet can be extended to any other tables.
Deployment
Configuration
Log on to Germain Workspace > left menu > Wizards > Oracle Database Server

Component: Engine
Feature Availability: 8.6.0 or later