Configure Monitoring for Oracle Database

📊 Monitor tablespaces and datafiles

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.

📚 Required Views and Permissions

View (Single Instance)	View (Multi-Instance / RAC)	Permission
V$SYSSTAT	GV$SYSSTAT	SELECT
V$SYSTEM_EVENT	GV$SYSTEM_EVENT	SELECT
V$SESSION	GV$SESSION	SELECT
V$SQL	GV$SQL	SELECT
V$SQLTEXT	GV$SQLTEXT	SELECT
V$SYSTEM_PARAMETER	GV$SYSTEM_PARAMETER	SELECT
V$RESOURCE_LIMIT	GV$RESOURCE_LIMIT	SELECT
V$SQLSTATS	GV$SQLSTATS	SELECT
V$SESSTAT	GV$SESSTAT	SELECT
V$STATNAME	GV$STATNAME	SELECT
V$DIAG_ALERT_EXT	GV$DIAG_ALERT_EXT	SELECT
V$LOCKED_OBJECT	GV$LOCKED_OBJECT	SELECT
V$LOG	V$LOG	SELECT
V$RECOVERY_FILE_DEST	V$RECOVERY_FILE_DEST	SELECT
DBA_DATA_FILES	DBA_DATA_FILES	SELECT
DBA_TABLESPACE_USAGE_METRICS	DBA_TABLESPACE_USAGE_METRICS	SELECT
DBA_TEMP_FILES	DBA_TEMP_FILES	SELECT
DBA_TEMP_FREE_SPACE	DBA_TEMP_FREE_SPACE	SELECT