Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Oracle agent query against dba_data_files and dba_temp_files affects host performance
설명
It seems that the SQL statement executed by the Foglight Oracle database agent against dba_data_files and dba_temp_files on the host takes a long time to run.
원인
The Datafile Storage collection process is affecting performance on one Oracle instance.
해결 방안
Navigate to the Databases dashboard
Enable the checkbox for the Oracle database agent(s) and click the Administer Agents button or select Settings | Administration from the Database Dashboard.
Select Collections
Highlight the "Tablespaces Storage" and click the Edit button
Adjust the collection frequencies or disable/enable the collection
Click the Save Changes button
Restart the database agent for the new collection frequency to come into effect.
