Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:documentation:03_monitoring:04_discovery [2021/08/27 14:13]
jimmy.olano old revision restored (2021/08/25 20:34)
en:documentation:03_monitoring:04_discovery [2021/09/16 09:17] (current)
Line 281: Line 281:
   * **Execute custom queries**: It executes custom queries.   * **Execute custom queries**: It executes custom queries.
   * **Custom queries**: It allows to define {{:wiki:pfms-discovery-application-oracle-oracle_detailed_3.png?linkonly|customized queries.}}   * **Custom queries**: It allows to define {{:wiki:pfms-discovery-application-oracle-oracle_detailed_3.png?linkonly|customized queries.}}
 +<WRAP center round tip 60%> \\ Important: the necessary permissions must be granted in order to be able to perform the queries; for example: \\ </WRAP> \\
 +<code>
 +
 +CREATE USER pandora IDENTIFIED BY pandora;
 +GRANT CREATE SESSION TO pandora;
 +GRANT SELECT any dictionary TO pandora;
 +GRANT SELECT ON V_$SYSSTAT TO pandora;
 +GRANT SELECT ON V_$STATNAME TO pandora;
 +GRANT SELECT ON gv$sysstat TO pandora;
 +GRANT SELECT ON v$sesstat TO pandora;
 +GRANT SELECT ON V_$INSTANCE TO pandora;
 +GRANT SELECT ON V_$LOG TO pandora;
 +GRANT SELECT ON SYS.DBA_DATA_FILES TO pandora;
 +GRANT SELECT ON SYS.DBA_FREE_SPACE TO pandora;
 +GRANT SELECT ON V_$parameter TO pandora;
 +GRANT SELECT ON dba_tablespaces TO pandora;
 +GRANT SELECT ON dba_data_files TO pandora;
 +GRANT SELECT ON dba_free_space TO pandora;
 +GRANT SELECT ON V$SQLSTATS TO pandora;
 +GRANT SELECT ON dba_tables TO pandora;
 +GRANT SELECT ON v$librarycache TO pandora;
 +GRANT SELECT ON v$rowcache TO pandora;
 +.
 +.
 +(others GRANTs necessary, for all tables used in the plugin configuration file)
 +.
 +.
 +--
 +-- if somebody still uses Oracle 8.1.7...
 +GRANT SELECT ON sys.dba_tablespaces TO pandora;
 +GRANT SELECT ON dba_temp_files TO pandora;
 +GRANT SELECT ON sys.v_$Temp_extent_pool TO pandora;
 +GRANT SELECT ON sys.v_$TEMP_SPACE_HEADER TO pandora;
 +GRANT SELECT ON sys.v_$session TO pandora;
 +
 +</code>