Oracle agent query against dba_data_files and dba_temp_files affects host performance (4307278)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Oracle agent query against dba_data_files and dba_temp_files affects host performance
Beschreibung

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.
Ursache

The Datafile Storage collection process is affecting performance on one Oracle instance.
Lösung
1. Navigate to the Databases dashboard
2. Enable the checkbox for the Oracle database agent(s) and click the Administer Agents button or select Settings | Administration from the Database Dashboard.
3. Select Collections
4. Highlight the "Tablespaces Storage" and click the Edit button
5. Adjust the collection frequencies or disable/enable the collection
6. Click the Save Changes button
7. Restart the database agent for the new collection frequency to come into effect.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5, 5.7.1, 5.6.11, 5.6.10, 5.6.7, 5.6.5; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Titel