Oracle Database
Features
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.
Configure
Deploy Germain Engine
Apply Monitoring to Oracle
Log on to Germain Workspace > left menu > Wizards > Oracle Database Server
