SQL Performance Investigator collection enabled but no execution plan nor any data being collected in SQL Performance Dashboard.
The following exception ORA-00942: table or view does not exist is observed in DB agent log.
YYYY-MM-DD SS.SS.SSS ERROR com.dell.dsgi.spi.common.utils.logger.LogUtils - baseSampler.java:115:com.dell.dsgi.spi.engine.base.olap.sample.BaseSampler.sampleAndAnalyze(): Error during sampling query
java.sql.SQLException: Failed to execute SQL:
Param: [500]
Connection Details: OracleProfile{host='xxxxxxx', instance='xxxxx', username='foglightuser', asSysDBA=false, ports='1521', properties={oracle.jdbc.ReadTimeout=900000}}
Grant Script is not executed for non-DBA foglight user
SQLPI requires permission/privileges to select data from database object tables/views.
For Oracle database, the following views are required for SQL PI to collect data. e.g
V$SESSION
V$SESSTAT
V$STATNAME
GV$INSTANCE
GV$SESSION
For complete listing, see Foglight for Database Deployment Guide, section 'Permissions for monitored databases'
Add the missing privileges by following the steps below:
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center