The Foglight monitoring user consumes a lot of resources on the monitoring Oracle instance causing performance issues.
Collection SQL queries take a long time to complete. Some over 11 hours.
In the agent logs where are Tablespace Storage and Datafile Storage collection errors
RESOLUTION 1
Please run the follow query
SELECT count() from dba_recyclebin;
Then purge the Oracle recyclebun
purge dba_recyclebin;
Then reactivate the collections (through the Oracle cartridge) and try monitoring again.
RESOLUTION 2
Update statistics on the monitored host
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
Then reactivate the collections (through the Oracle cartridge) and try monitoring again.
Please contact Quest Support if either of these two resolutions do not resolve the issue.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center