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
ERROR [INST1-lowPriorityPool-39464-[DBO_TablespacesStorage]] com.quest.qsi.fason.oracle.collection.processor.DBOInstanceProcessor - Failed to run DBOTablespacesStorageProcessor processor of DBO_TablespacesStorage collection of INST1 instance.
java.lang.RuntimeException: Failed to execute collection [DBO_TablespacesStorage], reason=IO Error: Socket read timed out- Profile:OracleProfile{host='hostname.example.com', instance='INST1', username='foglight', asSysDBA=false, ports='1521', properties={oracle.jdbc.ReadTimeout=900000}} Query: "-- – This software is confidential. Quest Software Inc., or one of its subsidiaries, has supplied this software to you – under terms of a license agreement, nondisclosure agreement or both. – – You may not copy, disclose, or use this software except in accordance with those terms. – – Copyright 2017 Quest Software Inc. ALL RI
... union all select bytes, tablespace_name ,con_id from cdb_undo_extents where status='EXPIRED' union all select bytes_free bytes, tablespace_name,con_id from sys.v_$temp_space_hea..._id AND t.con_id = fs.con_id AND t.con_id = u.con_id ) tbsp_storage where contents not in (DECODE(?,1,'UNDO',' '),DECODE(?,1,'TEMPORARY',' ')) and status!=(DECODE(?,1,'READ ONLY',' ')) and tablespace_name not in (DECODE(?,1,'SYSTEM',' '),DECODE(?,1,'SYSAUX',' ')) and rownum <= 2000 ", SQL-Parameters = [0],[0],[0],[0],[0],
