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

Deploy Germain Engine

Configuration

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

Component: Engine

Feature Availability: 8.6.0 or later