...
If you monitor ORACLE DB via external DB connection defined in SAP, then the user used in the DBCON has to have "read" authorization to following table and views:
...
| Info |
|---|
When you add new ORACLE system to monitoring pool the accessibility of those tables and views is checked automatically. You can check accessibility also via simple SQL statement. Type the statement in 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' ) Tables Accessible tables and views which are accessible will be listed after executing of the SQL. For missing ones you need an authorization. |
...