Return
-
Title
Oracle AWR report indicates frequent DBO cartridge SQL activity in top queries -
Description
Oracle AWR report indicates frequent DBO cartridge SQL activity in top queries. -
Cause
High frequency Foglight cartridge collections may always appear in Top Queries. This is expected in order to deliver the most current data to dashboards and rule processing. Collection frequency can also increase(example: 60 sec vs 300 sec) when viewing real-time views such as sessions, locks, waits, etc .
-
Resolution
- Frequently update statistics on objects
- Reindex when signifigant changes occur in the data
- Keep the Foglight Database Cartridge up to date, as monitoring queries may be updated and optimized in each release.
- Regularly review the databases hardware and resource requirements, and determine if they are sufficient to meet the current transaction processing requirements