(DI-2002) Oracle monitoring prerequisites

Owned by SNP
Last updated: Apr 15, 2020 by Marian Vidra
1 min read

You can monitor ORACLE database of version 11.2.0 and higher.

If you monitor ORACLE DB via external DB connection defined in SAP, then the user used in the DBCON needs to have "read" authorization to access following tables and views:

PRODUCT_COMPONENT_VERSION

V$OSSTAT

V$INSTANCE

V$DATABASE

GV$SYSSTAT

V$METRICNAME

GV$SYSMETRIC_HISTORY

GV$SGAINFO

GV$PGASTAT

GV$OSSTAT

GV$INSTANCE


When you add new ORACLE system to the monitoring pool, the accessibility of those tables and views is checked automatically.

You can check the accessibility also via simple SQL statement. Type the statement in a standard SAP tool ST04 / DB50 or via report ADBC_QUERY:

SELECT * FROM all_objects WHERE object_name IN ( 'PRODUCT_COMPONENT_VERSION', 'V$DATABASE', 'V$OSSTAT', 'V$INSTANCE', 'GV$INSTANCE', 'GV$OSSTAT', 'GV$PGASTAT', 'GV$SGAINFO', 'V$METRICNAME', 'GV$SYSMETRIC_HISTORY', 'GV$SYSSTAT' )

Accessible tables and views will be listed after executing of the SQL. For missing ones you need an authorization.